Excluding all 3bets where I'm facing all ins.

[fnopeaw]

Well, I added this filter, it's in my first post. This filter won't work because you can face an all in and at same time you can have a 4bet opp. Example.

Utg 100bbs
CO 112bbs
BB 20bbs


Utg raises to 3bbs, CO calls 3bbs, BB is all in, Utg raises to 40bbs, CO folds.

[kraada]

Yes that's where enum_face_allin comes into play -- that hand should count for that and be eliminated because of that portion of your filter.

[fnopeaw]

Filters : (cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_open_opp) AND (cash_hand_player_statistics.flg_p_4bet_opp AND
cash_hand_player_statistics.amt_p_3bet_facing>0) AND not cash_hand_player_statistics.enum_face_allin SIMILAR TO '(p|P)'

BTN: 173.82 BB
SB: 43.85 BB
BB: 234.08 BB
UTG: 220.11 BB
MP: 173.14 BB
CO: 208.34 BB

SB posts SB 0.5 BB, BB posts BB 1 BB

UTG raises to 3 BB, MP calls 3 BB, fold, fold, SB raises to 43.85 BB and is all-in, fold, UTG calls 40.85 BB, fold

Flop : (91.71 BB, 2 players) 6c 8s Jh

Turn : (91.71 BB, 2 players) As

River : (91.71 BB, 2 players) Jd

SB shows Kh Kc (Two Pair, Kings and Jacks) (Pre 72%, Flop 85%, Turn 5%)
UTG shows Qc Ah (Two Pair, Aces and Jacks) (Pre 28%, Flop 15%, Turn 95%)
UTG wins 91.15 BB


UTG is the active player.

This hand is shown after the filter above, I upload a ticket with this one ?

[WhiteRider]

Yes, please do.

[fnopeaw]

I did some tests. I created a new database then I imported this hand into this database and the filter worked without problem in this database so I realized that the problem was just 1 database. I got it fixed by purging the session containing this hand (and doing the process that this implies) and then I reimported the hand and it seems to be working well now.

[kraada]

Thanks for the update.

[fnopeaw]

Filter : (cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_open_opp) AND (cash_hand_player_statistics.flg_p_4bet_opp AND
cash_hand_player_statistics.amt_p_3bet_facing>0) AND not cash_hand_player_statistics.enum_face_allin SIMILAR TO '(p|P)'

BTN: 140.94 BB
SB: 100 BB
BB: 107.94 BB
UTG: 252.76 BB
MP: 181.64 BB
CO: 107.44 BB

SB posts SB 0.5 BB, BB posts BB 1 BB

fold, fold, fold, BTN raises to 2.5 BB, fold, BB raises to 8 BB, BTN raises to 19 BB, BB raises to 107.94 BB and is all-in, BTN calls 88.94 BB

Flop : (216.38 BB, 2 players) Jc 6h Tc

Turn : (216.38 BB, 2 players) 5s

River : (216.38 BB, 2 players) 7d

BB shows Jh Js (Three of a Kind, Jacks) (Pre 18%, Flop 83%, Turn 95%)
BTN shows Qc Qs (One Pair, Queens) (Pre 82%, Flop 17%, Turn 5%)
BB wins 215.82 BB


This hand is shown and it's good for what I want but I'm a bit confused about enum_face_allin and how it works. This seems to be working for all the 3bets I'm facing. As you can see in this hand I'm facing a 5bet all in but this hand is being shown so my question is : enum_face_allin evalues if our opponent is all-in only the first time we're facing a raise in a given street ?

[kraada]

It should be any all-in -- please attach the original hand history to a support ticket so we can look into what is going on in this specific case and make sure it gets fixed.

[fnopeaw]

No need to uload any ticket Kraada. The hand is just corrupted. I uploaded this hand into another database and the filter works as you stated so the problem is my database.

Can you give me the definitions and the possible values of these 3 columns :

enum_allin
enum_face_allin
enum_face_allin_action

[kraada]

enum_allin: This character is set to the street on which the player was all in during this hand. Possible values are “P” - Preflop, “F” - Flop, “T” - Turn, “R” - River, “N” Not all-in.

enum_face_allin: This character is set to the street on which the player faced an all-in. The character is in lowercase if the after a call the player could potentially lose more money to another player in the pot. The character is in uppercase if, after calling, the player could lose no more than the amount of the call. Possible values are: “P” Preflop without more potential losses beyond the call, “p” Preflop with more potential losses beyond the call, “F” Flop without more potential losses beyond the call, “f” Flop with more potential losses beyond the call, “T” Turn without more potential losses beyond the call, “t” Turn with more potential losses beyond the call, “R” River without more potential losses beyond the call, “r” River with more potential losses beyond the call, “N” Did not face an all-in.

enum_face_allin_action: This character is set to the player's action when facing an all-in. Possible values are “F” - Fold, “C” - Call, “R” - Raise, “N” - Did not face an all-in