Having trouble with adding expressions( Omaha) in My Report

[ugthemc]

I'm trying to run a Hand report on how I've been playing AAxx hands( in Omaha) by position.

I wanted to look at:

BB ( hero) vs MP RFI

And one squeeze spot:

BB(hero) vs MP RFI and BTN( cold call)


I tried adding the following expression for BB ( hero) vs MP RFI :

cash_hand_player_statistics.position = 8 and cash_hand_summary.str_aggressors_p LIKE '82' and cash_hand_summary.str_actors_p LIKE '28'

However, only 9 hands were displayed after I saved it, even though I have around 40 thousand hands played in my database.

Not sure where I went wrong, thanks

[ugthemc]

Also,

I tried editing the report filter where BB ( hero) 3bs vs MP RFI( who calls 3b) by adding the expression

cash_hand_player_statistics.position = 8 and cash_hand_summary.str_aggressors_p LIKE '828' and cash_hand_summary.str_actors_p LIKE '282'

I got a total of 5 hands!!

[Flag_Hippo]

I tried adding the following expression for BB ( hero) vs MP RFI :

cash_hand_player_statistics.position = 8 and cash_hand_summary.str_aggressors_p LIKE '82' and cash_hand_summary.str_actors_p LIKE '28'

However, only 9 hands were displayed after I saved it, even though I have around 40 thousand hands played in my database.

Not sure where I went wrong, thanks

This will only show you hands where you were the last to VPIP preflop e.g by calling and closing the action. This filter will not include hands where you 3bet+. To include hands with any combo of BB/MP subsequent actions you should instead use:

Code: Select all

cash_hand_player_statistics.position = 8 and cash_hand_summary.str_aggressors_p LIKE '82%' and cash_hand_summary.str_actors_p LIKE '28%'

For more information on pattern matching in PostgreSQL see this guide.

[ugthemc]

Thanks, I still only got 14 hands, but I think that may have more to do with the stakes I play at(a lot of limping and multi-way pots)

I have a follow-up question.

How would I add a position to make this spot a squeeze, such as:

BB(hero) vs MP RFI and BTN( cold call)

I tried adding the BTN position, like so:

cash_hand_player_statistics.position = 8 and cash_hand_summary.str_aggressors_p LIKE '820%' and cash_hand_summary.str_actors_p LIKE '208%'

I only got one hand, so that doesn't seem right

[Flag_Hippo]

BB(hero) vs MP RFI and BTN( cold call)

I tried adding the BTN position, like so:

cash_hand_player_statistics.position = 8 and cash_hand_summary.str_aggressors_p LIKE '820%' and cash_hand_summary.str_actors_p LIKE '208%'

I only got one hand, so that doesn't seem right

If you are not seeing the number of hands you expect then replay a hand and see if the hand actions match with what you were trying to achieve. With this you are testing for the BTN 3betting (the third number in the aggressors string). What you need is this which tests for the BTN being the second player to VPIP but not by 3betting:

Code: Select all

cash_hand_player_statistics.position = 8 and cash_hand_summary.str_aggressors_p LIKE '82%' and cash_hand_summary.str_aggressors_p NOT LIKE '820%'  and cash_hand_summary.str_actors_p LIKE '208%'

[ugthemc]

Thanks!