How to filter out hands with straddle

[GelaGoot]

I want to filter hands where I made the first raise preflop (flg_p_first_raise_made) and I have the opportunity to open the pot (flg_p_open_opp).
The problem is, that I had one session, where someone used straddle. These hands will show up in the report.
But I want to exclude these hands from the report.
So I could not find something like flg_p_facing_straddle or flg_hand_has_straddle.
There is only amt_straddle.
So how can I use this amt_straddle to find out, if this hand has a player that uses straddle so that I can exclude it from the report?

[GelaGoot]

UPDATE: I tried

cash_hand_player_statistics.id_hand NOT IN (SELECT id_hand FROM cash_hand_player_statistics WHERE amt_straddle<>0.00)

But this takes forever to load.

Can I put the return value of SELECT id_hand FROM cash_hand_player_statistics WHERE amt_straddle<>0.00 into a variable and use this instead of running the query for every hand?

[Flag_Hippo]

There aren't currently any hand specific filters for straddling but you could use an expression filter that pattern matches based on the hand history text from your poker site:

Code: Select all

cash_hand_histories.id_hand = cash_hand_player_statistics.id_hand and cash_hand_histories.history not like '%straddle%'

If your poker site uses different wording for straddling then you would need to edit the filter accordingly.

[GelaGoot]

cash_hand_histories.id_hand = cash_hand_player_statistics.id_hand and cash_hand_histories.history not like '%straddle%'

@Flag_Hippo
Thanks! This works and is very quick.