Expression filter for excluding certain players
Posted:
Wed Jan 20, 2021 2:31 pm
by PetarM
Hello,
I would like to make an expression filter that excludes certain players from the filtered hands.
For example I filter all the hands where SB open shoves but I want to exclude all the hands where player "Vilain" is SB and open shoves.
Thank you
Re: Expression filter for excluding certain players
Posted:
Thu Jan 21, 2021 10:48 am
by PetarM
Many thanks,
And if I want to add more players, should I copy/paste the line:
NOT 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')
or there might be a more efficient way
Thanks
Re: Expression filter for excluding certain players
Posted:
Thu Jan 21, 2021 3:05 pm
by Flag_Hippo
- Code: Select all
tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.flg_p_open_opp and tourney_hand_player_statistics.position = 9 and NOT 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 SIMILAR TO '(Villain1|Villain2)')
You can use more player names as long as you keep the same format e.g: '(Villain1|Villain2|Villain3|Villain4)'.