Filter for particular villain in a particular position

[carl91]

Hi there,

I'm trying to work out how to set up a filter for a specific villain being in a specific position. So currently I am running a hand report where Hero is the BB but I want to specify a particular villain to be in the SB. I assume it's an expression filter or combination of expression filters but I can't work out which ones to use.

Thanks.

[Flag_Hippo]

Cash games:

Code: Select all

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

Tournaments:

Code: Select all

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

Replace Villain with a screen name and leave the single quotes - those are needed.

[carl91]

Awesome, thanks.

Now how do I specify that players 0 to 6 don't limp first in.

[Flag_Hippo]

Presumably you don't want them raising either? For that you can use:

Code: Select all

cash_hand_summary.str_actors_p LIKE '9%'

which means that the SB was the first player to VPIP - see this post for more information on how the actors and aggressors strings work.