Question about a report filter

[potamito]

Having issues creating a Donk Flop report fitler that isolate the times when the hand reaches showdown without hero/villain hand improving on later streets....thoughts?

[Flag_Hippo]

(cash_hand_player_combinations.flg_f_highcard AND cash_hand_player_combinations.flg_r_highcard) OR (cash_hand_player_combinations.flg_f_1pair AND cash_hand_player_combinations.flg_r_1pair) OR (cash_hand_player_combinations.flg_f_2pair AND cash_hand_player_combinations.flg_r_2pair) OR (cash_hand_player_combinations.flg_f_threeoak AND cash_hand_player_combinations.flg_r_threeoak) OR (cash_hand_player_combinations.flg_f_straight AND e.t.c.

[potamito]

I want the filter to isolate the times villain donked the flop with top pair and the hand reaches showdown without his hand improving, i mean he donked flop with exactly top pair and reached showdown with exactly top pair.

[Flag_Hippo]

If that's from the perspective of the villain donk betting you can use this:

Code: Select all

cash_hand_player_statistics.flg_p_face_raise AND NOT (cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND cash_hand_player_statistics.flg_f_bet AND NOT (cash_hand_player_statistics.flg_f_cbet_opp) AND ((cash_hand_summary.cnt_players > 2 AND cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position) or (cash_hand_summary.cnt_players = 2 and cash_hand_player_statistics.flg_blind_b)) AND cash_hand_player_combinations.flg_f_1pair AND cash_hand_player_combinations.id_f_hand_strength = 3 AND cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 3