Filter "vs specific player"

[Kalledrengen]

I'd like to be able to filter hands so they only show hands I've played vs a specific player. I searched and read through a bunch of threads here on the forum but didn't learn much. I'm talking about heads up. So yeah I know I can just choose villain as a player but kind of annoying having to do it all backwards. Like if I want to see how much I've c-bet the flop I'll have to filter for c/r opportunities etc. instead. Wasn't it possible in the old version to filter for "vs specific player"?

Also I downloaded a "delayed turn c-bet" stat. I couldn't find "fold to delayed turn c-bet" which I'd like to have (for heads up).

Thanks

[kraada]

There wasn't a filter for that in PT3, but you can do this with a custom filter expression in the My Reports area.

The filter:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'Villain Name')

Will filter to all hands where Villain Name was dealt in. Note that you need the single quotes around the opponent's screen name.

You can use this in the My Reports tab then filter as you'd like further to see things from your perspective.

[sawwee]

There wasn't a filter for that in PT3, but you can do this with a custom filter expression in the My Reports area.

The filter:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'Villain Name')

Will filter to all hands where Villain Name was dealt in. Note that you need the single quotes around the opponent's screen name.

You can use this in the My Reports tab then filter as you'd like further to see things from your perspective.

Kraada,

Could you please post the same filter for tournament hands, too?

Thanks a lot!

[kraada]

For tournaments it is:

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.id_player = p.id_player and p.player_name = 'Villain Name')

[sawwee]

For tournaments it is:

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.id_player = p.id_player and p.player_name = 'Villain Name')

Thank you!

[pt4pt4pt4]

Kraada you put in a lot of work with these custom filters and they are all very useful.

Would be nice to have a sticky dedicated to all of your custom stats and filters, since many of these go to waste since no one sees them buried in posts.

IMO

[kraada]

A walkthrough/tutorial to these kinds of things is on my list of stuff to do. Hopefully we'll see that happen sometime in 2013.

[sawwee]

For tournaments it is:

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.id_player = p.id_player and p.player_name = 'Villain Name')

Is it possible to save this fiter? Or do I have to copy it eveytime I want to use it?

[kraada]

If you save the report that filter will be saved with your report.

[sawwee]

If you save the report that filter will be saved with your report.

Indeed, thanks!