Unfortunately I'm more comfortable in SQL than in PokerTracker4. The query below produces a list of hand id's and bomb pot table flags, setting the flag to true for any hand that is at a table that has a bomb pot hand in my DB that day. (I'm considering a hand a bomb pot if there were no blinds, there were antes, and the number of people dealt into the hand is the same as the number of people who saw the flop.)
My question is how I would incorporate this flag into a report so I can investigate the difference between bomb pot tables and non-bomb pot tables?
- Code: Select all
select distinct
id_hand,
exists(
select 1 from (
select
id_table,
date(date_played) date_played_dt
from cash_hand_player_statistics natural join cash_hand_summary
where cnt_players = cnt_players_f
group by id_table, id_hand, date(date_played)
having min(amt_ante) > 0 and max(amt_blind) = 0
) x
where s.id_table = x.id_table and date(s.date_played) = x.date_played_dt
) bomb_pot_table_flag
from cash_hand_summary s
As I read this, I'll probably modify the query so it considers a hand as being at a bomb pot table if there was a bomb pot hand played at it within an hour. That way I don't miscategorize a few hands played before or after a calendar date change. But that tweak would be simple enough. If I knew tables never changed bomb pot status, then I could do away with the date field entirely, but I digress!