Custom Over Bet Report

[Criminal Bizzy]

I have been trying to create a report that compares how often I win over bet shoves to when I lose over bet shoves. I have searched through the forums and found some stuff that got me part of the way there but its not exactly what I am looking for. I know there is a file that shows all of the database fields but I can't find that post. So my first question is where can I find that file so I can see what the database fields are to build custom queries?

Next I am going to ask for some assistance building the query that I am looking for. I was able to filter out hands/stats down to number of times active player faced an all in bet on the river... but I am not able to compare it to losses with simple filters. What I would like is as follows:

If hand has 2 players on flop, turn, or river
and
Villain over bet all in is < 2:1 pot odds for hero
and
It is hero's action

count number of times hero calls and wins (show total amount won)
count number of times hero calls and loses (show total amount loss)

[Flag_Hippo]

I have been trying to create a report that compares how often I win over bet shoves to when I lose over bet shoves. I have searched through the forums and found some stuff that got me part of the way there but its not exactly what I am looking for. I know there is a file that shows all of the database fields but I can't find that post. So my first question is where can I find that file so I can see what the database fields are to build custom queries?

The meaning of database fields with the same names haven't changed in any significant way from PokerTracker 3.

PokerTracker 3 Database Schema Documentation

The PT4 schema documentation has not been published but schema.postgres.sql is available in "C:\Program Files (x86)\PokerTracker 4\Data\Schemas". Also forum member 'Bininu' made their own schema document for PokerTracker 4 available in this thread.

What I would like is as follows:

If hand has 2 players on flop, turn, or river
and
Villain over bet all in is < 2:1 pot odds for hero
and
It is hero's action

count number of times hero calls and wins (show total amount won)
count number of times hero calls and loses (show total amount loss)

Code: Select all

cash_hand_player_statistics.flg_won_hand AND ((cash_hand_summary.cnt_players_f = 2 AND cash_hand_player_statistics.val_f_bet_facing_pct > 50 AND cash_hand_player_statistics.amt_f_bet_facing >= cash_hand_player_statistics.amt_f_effective_stack) OR (cash_hand_summary.cnt_players_t = 2 AND cash_hand_player_statistics.val_t_bet_facing_pct > 50 AND cash_hand_player_statistics.amt_t_bet_facing >= cash_hand_player_statistics.amt_t_effective_stack) OR (cash_hand_summary.cnt_players_r = 2 AND cash_hand_player_statistics.val_r_bet_facing_pct > 50 AND cash_hand_player_statistics.amt_r_bet_facing >= cash_hand_player_statistics.amt_r_effective_stack))

Code: Select all

NOT cash_hand_player_statistics.flg_won_hand AND cash_hand_player_statistics.flg_showdown AND ((cash_hand_summary.cnt_players_f = 2 AND cash_hand_player_statistics.val_f_bet_facing_pct > 50 AND cash_hand_player_statistics.amt_f_bet_facing >= cash_hand_player_statistics.amt_f_effective_stack) OR (cash_hand_summary.cnt_players_t = 2 AND cash_hand_player_statistics.val_t_bet_facing_pct > 50 AND cash_hand_player_statistics.amt_t_bet_facing >= cash_hand_player_statistics.amt_t_effective_stack) OR (cash_hand_summary.cnt_players_r = 2 AND cash_hand_player_statistics.val_r_bet_facing_pct > 50 AND cash_hand_player_statistics.amt_r_bet_facing >= cash_hand_player_statistics.amt_r_effective_stack))

[Criminal Bizzy]

Oh ok... so I should be posting full on SQL queries? I was trying to piece together stuff based on what I was finding in the list of options that you could insert in Expression filters. Is the second query what I am not looking for?

Thanks for typing out of the query so far, this makes a lot more sense than what I had been reading last night.

[Flag_Hippo]

Oh ok... so I should be posting full on SQL queries?

It depends. If you need assistance with something and have expressions you've been working please post them and we can then give guidance.

I was trying to piece together stuff based on what I was finding in the list of options that you could insert in Expression filters. Is the second query what I am not looking for?

Thanks for typing out of the query so far, this makes a lot more sense than what I had been reading last night.

The queries should give you what you want if I am understanding your original post correctly. The first query is for the hands you won and the second query is for the hands you lost.