Bets or Raises with Less Than a Board Reveal

[wallacedavidl]

By the way, is there a flg for each hand group on each street, i.e., flg_f_1pair, flg_t_1pair and flg_r_1pair, for the Flop, Turn and River respectively?

[wallacedavidl]

Also, is there a complete definition of the table somewhere with data types and descriptions of all the columns?

[Flag_Hippo]

Can you send the code for a "Straight" board texture, in the way you did for a "Monotone" one?

Can you please be more specific. Do you want flops where a straight is possible, rivers where there is a straight on the board or something else?

By the way, is there a flg for each hand group on each street, i.e., flg_f_1pair, flg_t_1pair and flg_r_1pair, for the Flop, Turn and River respectively?

Yes.

Also, is there a complete definition of the table somewhere with data types and descriptions of all the columns?

You can view column descriptions in PokerTracker 4 via 'Configure -> Statistics -> Columns'. If you want more information on the PokerTracker database schema then that's not been published for PokerTracker 4 but the meaning of database fields with the same names haven't changed in any significant way from PokerTracker 3:

PokerTracker 3 Database Schema Documentation

[wallacedavidl]

Hey Team -

I was successfully able to create a column expression that inclusively uses:
cash_hand_player_combinations.flg_f_1pair
cash_hand_player_combinations.flg_t_1pair
cash_hand_player_combinations.flg_r_1pair
AND
cash_hand_player_combinations.id_f_hand_strength
cash_hand_player_combinations.id_t_hand_strength
cash_hand_player_combinations.id_r_hand_strength

referencing the FLOP, TURN and RIVER. So, my question is...

Are their additional id_x_hand_strength values that I need to consider for the TURN (cash_hand_player_combinations.id_t_hand_strength) and RIVER (cash_hand_player_combinations.id_r_hand_strength), which go beyond what you've provided for cash_hand_player_combinations.id_f_hand_strength?

[wallacedavidl]

Hey, Thanks for the Schema. Concerning the Straight Board request, it's a Board with 3 Card to a Straight, FLOP, TURN or RIVER.

[Flag_Hippo]

Are their additional id_x_hand_strength values that I need to consider for the TURN (cash_hand_player_combinations.id_t_hand_strength) and RIVER (cash_hand_player_combinations.id_r_hand_strength), which go beyond what you've provided for cash_hand_player_combinations.id_f_hand_strength?

There isn't anything else - it's all in the original post. The 'x' in id_x_hand_strength just gets substituted for the street you want (f, t or r) and if you read that post you will see that some of those are only valid for the turn or river (such as four of a kind on the board).

Concerning the Straight Board request, it's a Board with 3 Card to a Straight, FLOP, TURN or RIVER.

I'm still not sure exactly what you want. In PokerTracker 4 go to 'More Filters -> Board Texture -> Board Connectedness' and refer to the descriptions you see there. Also if you apply the filter with logging enabled (turn that on via 'Configure -> Options') you can extract the query you need from the log file yourself - see this post for an example.

[wallacedavidl]

Hey Team -

After review of the schema, please enlighten me on the following...

Is it True that for a specific hand, I can't reference cash_hand_player_combinations.id_r_hand_strength values related to a Pair, Flush and Straight groups simultaneously?

I'm asking because, let's say in the case that I ONLY had a pair in a hand, as defined by cash_hand_player_combinations.flg_f_1pair, BUT there's 3 Boarded Cards to a Made Flush or Straight. Since my hand flag is set to 1pair, I wouldn't be able to reference intel about a 3 Cards to a Made Flush or Straight Board, unless through the provided Modulo statements that create Standalone Board Textures that I can reference. Is there a way for me to reference flg_f_straight and flg_f_flush board characteristics when I'm flagged as flg_f_1pair?

Thanks,
David

[wallacedavidl]

Just saw your last response. I will take a look at the other post.

[wallacedavidl]

Hey Team -

I missed your direction earlier in this thread to run a report and add a Board filter and then retrieve the result from the pokertracker4.log. I enabled logging. Then when to View Stats -> Statistics -> More Filters, and then added various Board Textures for Bets and Raises with some Paired and Unpaired hands. Below is the Psuedo Code of the expression. I clicked Save & Apply Filters, but didn't find anything for the timestamp I performed this in the LOG. What am I doing wrong?

By the way, this is my first use of the reporting engine and it's great.

((Overcards - All Three Streets No Overcards) AND ((Made One Pair On Any Street) OR (Made One Pair On Any Street Using Two Hole Cards Middle Pair to the Board OR Underpair to the Board) OR (Made One Pair On Any Street Using One Hole Card Middle Pair OR Lower Pair))) AND ((Suits on Flop All Cards of One Suit) OR (Suits on Turn Turn Card is Third Card of Suit) OR (Suits on River Three Cards of Any One Suit) OR (Connectedness on Flop Any Made Straight is Possible) OR (Connectedness on Turn Any Made Straight is Possible) OR (Connectedness on River Any Made Straight is Possible)) AND ((Turn is an Overcard) OR (River is an Overcard) OR ((Broadway Cards (T, J, Q, K, A) One or more) OR (Middle Cards (6, 7, 8, 9) One or more) OR (Wheel Cards (A, 2, 3, 4, 5) One or more))) AND ((Saw Flop) OR (Bet Flop Any Flop Bet) OR (Raised Flop Any Flop Raise)) OR ((Bet Turn Any Turn Bet) OR (Raised Turn Any Turn Raise)) OR ((Saw River) OR (Bet River Any River Bet) OR (Raised River Any River Raise))

[Flag_Hippo]

I'm asking because, let's say in the case that I ONLY had a pair in a hand, as defined by cash_hand_player_combinations.flg_f_1pair, BUT there's 3 Boarded Cards to a Made Flush or Straight. Since my hand flag is set to 1pair, I wouldn't be able to reference intel about a 3 Cards to a Made Flush or Straight Board, unless through the provided Modulo statements that create Standalone Board Textures that I can reference. Is there a way for me to reference flg_f_straight and flg_f_flush board characteristics when I'm flagged as flg_f_1pair?

flg_f_straight and flg_f_flush don't exist in the database schema for the board - that is for player hand strengths only. Referencing the board texture will require testing cash_hand_summary.card_1 through to cash_hand_summary.card_5.

I clicked Save & Apply Filters, but didn't find anything for the timestamp I performed this in the LOG. What am I doing wrong?

Did you restart PokerTracker 4 after enabling logging? Did you open the log file before or after the query? If after was the view of the log file refreshed? I would just recommend applying the filter, opening/refreshing the log file and scrolling to the bottom of the log file and the query should be there.