Constructing a Limp CBet Stat

[TapDancingSquid]

I'm trying to construct a limp cbet stat for these 3 handed games that only counts hands where a player is the first to enter the pot by limping, isn't iso'ed and then cbets the flop.

I tried this below but it's not working. What am I missing?

Thanks


lookup_actions_p.action = 'C' AND lookup_actions_f.action = 'B%' AND tourney_hand_summary.cnt_players = 3 AND tourney_hand_player_statistics.flg_p_open_opp

[kraada]

In what way is it not working? At first glance it looks ok to me.

[TapDancingSquid]

I put it into a hand report as an expression filter to check and see if it works. No hands came up, which is impossible.

So I figured I made a mistake somewhere.

[kraada]

How large is your database? If it's small this may just not have happened yet.

[TapDancingSquid]

3000 games at these games...

[kraada]

But do you ever do it? If you made a custom Hand report and filtered on active player and never open limped it would still show nothing.

[TapDancingSquid]

Ya I limp quite a bit. It should definitely be showing up.

[kraada]

If you create a Hand report without this filter expression and go to More Filters and use that to filter for your situation, how many hands do you see? You can filter for limping in Actions and Opportunities -> Preflop -> Calls, open opportunity in A&O -> Preflop -> Opportunities, number of players in Hand Details -> Number of Players and the flop bet in A&O -> Flop -> Bets

[TapDancingSquid]

That works, have lots of hands there. Over 500 and they seem to all meet the criteria. For what it's worth continuation bet didn't work but any bet did, guess that makes sense though since we didn't raise pre.

[WhiteRider]

The problem is:
lookup_actions_f.action = 'B%'

Equals (=) tests that the actions string exactly matches, but % isn't a valid action character so that will never match.
For wildcard searches like this you need to use 'LIKE'

lookup_actions_p.action = 'C' AND lookup_actions_f.action LIKE 'B%' AND tourney_hand_summary.cnt_players = 3 AND tourney_hand_player_statistics.flg_p_open_opp