Filtering on player tags

[jiazu]

Is it possible to filter out players that you have tagged with a certain label?

For instance, showdown pots vs tags.

[ img ]

[WhiteRider]

I don't think it is possible to filter like that using the general filters. It may be possible in a custom report but I'll have to investigate when I have a little more time.

[kraada]

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)

[jiazu]

Thanks kraada, that's great!

[ img ]

It would be perfect if you could name and save these so you could quickly access filters for showdowns vs different types of villains. For instance, I tag shortstackers purple and regs orange. Our strategy is different vs each of these player types (and vs others) so filtering for this is very useful.

edit: oh wait, you can by just saving them as a custom report. sweet!

[jiazu]

Is it also possible to filter on hands played vs a particular villain, by screenname?

[WhiteRider]

This filter will give you hands played against Player X.

( 0 < (SELECT count(hhps2.id_hand) FROM cash_hand_player_statistics hhps2 WHERE hhps2.id_hand = cash_hand_player_statistics.id_hand AND hhps2.id_player = (SELECT p.id_player FROM player p WHERE player_name='Player X')) )

[summy]

Is there a way to filter the report by pokerstars's labels/notes instead?

[kraada]

PokerTracker doesn't know what your note labels are in PokerStars, so that is not possible.

[summy]

Fair enough I'll use the pt4 one instead then.

Can you be so kind and give me the filter that you posted including nonshowdown winnings?
I tried removing 'chps.flg_showdown' but that will include winnings vs other players that don't have the notes on them :/.

[kraada]

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)