potamito wrote:* Open Shover was opening the pot
potamito wrote:tourney_hand_player_statistics.cnt_p_face_limpers = 0
The caller isn't facing any limpers - they are facing a shove so this will not work. If you do not want to count shoves over limpers you either need to test the aggressors/actors strings or use a subquery for aggressor.
potamito wrote:AND NOT(tourney_hand_player_statistics.flg_p_open_opp)
This is redundant since the player is already facing a raise.
potamito wrote:But i tested the expressions on a hand report and is still not isolating the situation im looking for...
Examples? Presumably you are seeing hands where the player didn't just call an open shove - this is because
tourney_hand_player_statistics.enum_face_allin_action is just the action the player takes after facing an all-in so it's possible they made other actions before that so if you want to specify a players actions preflop you can also use
lookup_actions_p.action. If you seeing other types of hands you don't want to see
this thread for details on how you can test/compare the aggressors/actors strings to get what you want.