Notes - Report / Stat

[zerozero]

I like to have an overview about all players with player-notes in my db.

First I created a stat "PlayerNotes" (=notes.notes) in the 'holdem cash player statistics' and added the stat to the "Summary -> Player Summary"-tab, but it didn't work.
Second I tried to create a stat, that simply checks if there is a player note (if[holdem_hand_player_detail.flg_note AND notes.enum_type=p, 1,0] but it didn't work, too.
:(

Maybe someone could help and creates a working stat for the summary, or a report which filters the players with player-notes?
(only player-notes, not session- or hand-notes)
Any help would be greatly appreciated!

[kraada]

Using the holdem_hand_player_detail table won't get you what you're looking for. You want your column to be:
if[player_real.flg_note, 1, 0]

It will have a value of 1 for players with notes, and 0 for players without notes. You should then be able to create a report using this column as a filter and it should work properly.

[zerozero]

Using the holdem_hand_player_detail table won't get you what you're looking for. You want your column to be:
if[player_real.flg_note, 1, 0]

Thank you for help, this works properly! :)
(Now I'm able to copy player-notes manually from db to db as long as there is no notes export/import-feature)

[zerozero]

*twice posted*

[kraada]

We do hope that the note export will be coming soon, though, for what that's worth.