Noted/Un-noted Players

[evylinda]

I'd like to be able to run a report that would show, along with other stats, whether or not there are notes on a player.

[kraada]

Notes from NoteTracker, notes you typed in, or both?

[evylinda]

Notes from NoteTracker, notes you typed in, or both?

Both would be great!

[kraada]

Ok, I've zipped up and attached three reports for you - one of which shows players with any notes, one of which shows players with manually entered notes and the last of which shows players with NoteTracker notes.

These are all cash games reports and you can add whatever other stats you'd like - and they should convert to tournament just fine as well.

[evylinda]

Thank you very much! The "Manual Notes" is valuable, but the other two are inaccurate because a small sampling shows that some players have no notes at all.

However, I apologize for not being more precise about my request. What I've been doing is to run a report, sorted by number hands, in order to identify my regular opponents. Then, while replaying their hands, I write notes on them, but as the list grows I sometimes select a player that I've already reviewed. It would save time if the report had a column indicating which players already had manual notes.

[kraada]

I see. I'll leave those reports up though because others may find them useful - one thing to be aware of, I do think giving a player a color counts as a note for this purpose, so that may be why you're seeing some players without typed notes being included.

You have a couple of options for your current report. You could add the following filter expression:

player.id_player not in (SELECT n.id_x from notes n where enum_type = 'P')

And that would limit your report to only players who do not have manual notes entered. Then as you entered notes on players and reviewed them, they wouldn't show up again when that report was refreshed.

We plan on including more ways to manually edit and see who has notes but that functionality is unfortunately not ready yet.

[evylinda]

The filter works beautifully! Thank you!