Page 1 of 3

Filtering on player tags

PostPosted: Sat Feb 18, 2012 1:38 pm
by jiazu
Is it possible to filter out players that you have tagged with a certain label?

For instance, showdown pots vs tags.

Image

Re: Filtering on player tags

PostPosted: Sat Feb 18, 2012 5:51 pm
by 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.

Re: Filtering on player tags

PostPosted: Sun Feb 19, 2012 12:15 pm
by 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)

Re: Filtering on player tags

PostPosted: Wed Feb 22, 2012 6:27 pm
by jiazu
Thanks kraada, that's great!

Image

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!

Re: Filtering on player tags

PostPosted: Wed Feb 22, 2012 6:47 pm
by jiazu
Is it also possible to filter on hands played vs a particular villain, by screenname?

Re: Filtering on player tags

PostPosted: Thu Feb 23, 2012 5:41 am
by 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')) )

Re: Filtering on player tags

PostPosted: Sun Aug 18, 2013 7:15 pm
by summy
Is there a way to filter the report by pokerstars's labels/notes instead?

Re: Filtering on player tags

PostPosted: Mon Aug 19, 2013 8:53 am
by kraada
PokerTracker doesn't know what your note labels are in PokerStars, so that is not possible.

Re: Filtering on player tags

PostPosted: Mon Aug 19, 2013 3:07 pm
by 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 :/.

Re: Filtering on player tags

PostPosted: Mon Aug 19, 2013 3:20 pm
by 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)

highfalutin