Hi
I am looking for an opportunity to see requests sent to the database while defining/changing filters in "More filters" tab. (For instance number of players)
I tried logging DBControlPanel option (and other options), but there is no such data in the log file.
I am sure it is possible to get that info while using PT3, but since HM2 stores/organizes info in the database differently, the PT3 requests is not applicable to HM2 database.
Could you tell me where I could find that info.
Thank you in advance
It is how it looks in PT3 (its only a part of the request)
SELECT (cash_hand_summary.id_hand) as "id_hand", (cash_hand_summary.id_site) as "id_site", (cash_hand_summary.hand_no) as "hand_no", (cash_hand_summary.id_gametype) as "id_gametype_summary", (cash_hand_summary.flg_note) as "flg_note", (cash_hand_summary.flg_tag) as "flg_tag", (timezone('UTC', cash_hand_player_statistics.date_played + INTERVAL '0 HOURS')) as "date_played", (cash_hand_player_statistics.id_limit) as "id_limit", (cash_hand_player_statistics.amt_won) as "amt_won", (cash_limit.limit_currency) as "limit_currency", ((case when( cash_hand_player_statistics.val_curr_conv != 0) then cash_hand_player_statistics.val_curr_conv*cash_han d_player_statistics.amt_won else 0.0 end)) as "amt_won_curr_conv", ( (CASE WHEN ( cash_limit.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_won * 1.0 )/( cash_limit.amt_bb)) ELSE 0 END) ) as "amt_bb_won", (CASE WHEN ( (cash_limit.amt_bb) ) <> 0 THEN (( (cash_hand_player_statistics.amt_expected_won) * 1.0 )/( (cash_limit.amt_bb) )) ELSE 0 END) as "amt_expected_bb_w