How to make a filter for villain has a set in 3Bet pot

[PokerFedor82]

Hi,
How to make a filter for villain has a set in 3bet pot?

ex: villain open raise, I 3bet then villain has a set in flop or later street

[Flag_Hippo]

Filtering for villains hand strength will require an expression filter with a subquery:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_hand_player_combinations chpc where chps.id_player = chpc.id_player and chps.id_hand = chpc.id_hand and not chps.flg_hero and ((chpc.flg_f_threeoak AND chpc.val_f_hole_cards_used = 2 AND chpc.id_f_hand_strength >= 4) OR (chpc.flg_t_threeoak AND chpc.val_t_hole_cards_used = 2 AND chpc.id_t_hand_strength >= 4) OR (chpc.flg_r_threeoak AND chpc.val_r_hole_cards_used = 2 AND chpc.id_r_hand_strength >= 4)))

You can use this expression filter in 'My Reports' by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. For more on how the SELECT query works see here.

[PokerFedor82]

Thank you <3