Filtering on player tags

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Filtering on player tags

Postby jiazu » Sat Feb 18, 2012 1:38 pm

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

For instance, showdown pots vs tags.

Image
jiazu
 
Posts: 111
Joined: Wed Sep 24, 2008 9:46 pm

Re: Filtering on player tags

Postby WhiteRider » Sat Feb 18, 2012 5:51 pm

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.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Filtering on player tags

Postby kraada » Sun Feb 19, 2012 12:15 pm

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)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Filtering on player tags

Postby jiazu » Wed Feb 22, 2012 6:27 pm

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!
jiazu
 
Posts: 111
Joined: Wed Sep 24, 2008 9:46 pm

Re: Filtering on player tags

Postby jiazu » Wed Feb 22, 2012 6:47 pm

Is it also possible to filter on hands played vs a particular villain, by screenname?
jiazu
 
Posts: 111
Joined: Wed Sep 24, 2008 9:46 pm

Re: Filtering on player tags

Postby WhiteRider » Thu Feb 23, 2012 5:41 am

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')) )
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Filtering on player tags

Postby summy » Sun Aug 18, 2013 7:15 pm

Is there a way to filter the report by pokerstars's labels/notes instead?
summy
 
Posts: 36
Joined: Wed Mar 16, 2011 5:39 am

Re: Filtering on player tags

Postby kraada » Mon Aug 19, 2013 8:53 am

PokerTracker doesn't know what your note labels are in PokerStars, so that is not possible.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Filtering on player tags

Postby summy » Mon Aug 19, 2013 3:07 pm

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 :/.
summy
 
Posts: 36
Joined: Wed Mar 16, 2011 5:39 am

Re: Filtering on player tags

Postby kraada » Mon Aug 19, 2013 3:20 pm

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)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 56 guests

cron