kraada wrote:To make it include only hands that didn't go to showdown instead you use:
cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p, notes n where p.id_player = chps.id_player and not(chps.flg_showdown) and n.id_x = p.id_player and n.enum_type = 'P' and n.id_color = X)
Ah I was mistaken the first filter did include results vs players that don't have the tag.
I'd like to only see the difference in winnings/losses vs a tagged group and exclude any other winnings/losses coming from other players.
Should have both showdown winnings and nsd (+folded blinds).
Here you made the same thing for pt3 with icons for example:
https://www.pokertracker.com/forums/vie ... 18&t=29371pt4pt4pt4 wrote:kraada wrote:Using this custom filter in the blue Filters link will get you all hands that went to showdown that included a player of the color whose number you put in for X. The numbers are 1 through 8 in the order you see them in your screenshot (1 = yellow, 2 = green, 3 = cyan, etc).
cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p, notes n where p.id_player = chps.id_player and chps.flg_showdown and n.id_x = p.id_player and n.enum_type = 'P' and n.id_color = X)
Can I Tag all the players in my DB through stats / reports rather than manual entry with the Note Editor HUD option?
I think you could do it with those batch files as well.
You can export notes within database->notes.
There is no autorating like in PT3 however :\.