Is "Last session filter" broken?

[4StarGen]

https://i.imgur.com/h3KPMcR.png

I want to review my last session hands, but when I select that filter, nothings pops up.
I have no other filters apply, so I was wondering whether it is a problem on my end

[Flag_Hippo]

I cannot reproduce this so can you please attach a screenshot of your entire PokerTracker 4 report window either here or privately in a Support Ticket.

[4StarGen]

I've filtered for my last 1 session as you can see just few hands are displayed while I've played this morning 500 hands
https://i.imgur.com/hmvFhZ3.png

Here's the query:

Code: Select all

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",
  (
    (
      case when(
        cash_hand_player_statistics.val_curr_conv != 0
      ) then cash_hand_player_statistics.val_curr_conv * cash_hand_player_statistics.amt_won else 0.0 end
    )
  ) as "amt_won_curr_conv",
  (
    cash_hand_player_statistics.id_final_hand
  ) as "id_final_hand",
  (
    cash_hand_player_statistics.flg_showed
  ) as "flg_showed",
  (
    cash_hand_player_statistics.enum_folded
  ) as "enum_folded",
  (
    cash_hand_player_statistics.holecard_1
  ) as "id_holecard1",
  (
    cash_hand_player_statistics.holecard_2
  ) as "id_holecard2",
  (
    cash_hand_player_statistics.holecard_3
  ) as "id_holecard3",
  (
    cash_hand_player_statistics.holecard_4
  ) as "id_holecard4",
  (lookup_actions_p.action) as "str_actions_p",
  (cash_hand_summary.card_1) as "id_flop1",
  (cash_hand_summary.card_2) as "id_flop2",
  (cash_hand_summary.card_3) as "id_flop3",
  (lookup_actions_f.action) as "str_actions_f",
  (cash_hand_summary.card_4) as "id_turn",
  (lookup_actions_t.action) as "str_actions_t",
  (cash_hand_summary.card_5) as "id_river",
  (lookup_actions_r.action) as "str_actions_r",
  (cash_hand_summary.amt_pot) as "amt_pot",
  (cash_limit.limit_currency) as "limit_currency",
  (cash_hand_summary.amt_rake) as "amt_rake"
FROM
  cash_hand_player_statistics,
  cash_hand_summary,
  lookup_actions lookup_actions_p,
  lookup_actions lookup_actions_f,
  lookup_actions lookup_actions_t,
  lookup_actions lookup_actions_r,
  cash_limit
WHERE
  (
    cash_hand_summary.id_hand = cash_hand_player_statistics.id_hand
    AND cash_hand_summary.id_limit = cash_hand_player_statistics.id_limit
  )
  AND (
    lookup_actions_p.id_action = cash_hand_player_statistics.id_action_p
  )
  AND (
    lookup_actions_f.id_action = cash_hand_player_statistics.id_action_f
  )
  AND (
    lookup_actions_t.id_action = cash_hand_player_statistics.id_action_t
  )
  AND (
    lookup_actions_r.id_action = cash_hand_player_statistics.id_action_r
  )
  AND (
    cash_limit.id_limit = cash_hand_player_statistics.id_limit
  )
  AND (
    cash_limit.id_limit = cash_hand_summary.id_limit
  )
  AND (
    cash_hand_player_statistics.id_player = (
      SELECT
        id_player
      FROM
        player
      WHERE
        player_name_search = E 'X'
        AND id_site = '100'
    )
  )
  AND (
    (
      cash_hand_player_statistics.id_hand IN (
        SELECT
          id_hand
        FROM
          cash_hand_player_statistics
        WHERE
          (
            cash_hand_player_statistics.id_player = (
              SELECT
                id_player
              FROM
                player
              WHERE
                player_name_search = E 'Xr'
                AND id_site = '100'
            )
          )
          AND (
            cash_hand_player_statistics.id_gametype = 1
          )
          AND (
            (
              (
                (
                  (
                    (
                      cash_hand_player_statistics.id_session in (
                        SELECT
                          ctss.id_session
                        from
                          cash_table_session_summary ctss
                        WHERE
                          ctss.id_player = (
                            SELECT
                              id_player
                            FROM
                              player
                            WHERE
                              player_name_search = E 'X'
                              AND id_site = '100'
                          )
                        ORDER BY
                          id_session DESC
                        LIMIT
                          1
                      )
                    )
                  )
                )
              )
            )
          )
        ORDER BY
          (
            timezone(
              'UTC', cash_hand_player_statistics.date_played + INTERVAL '0 HOURS'
            )
          ) desc
        LIMIT
          100
      )
    )
  )
ORDER BY
  (
    timezone(
      'UTC', cash_hand_player_statistics.date_played + INTERVAL '0 HOURS'
    )
  ) desc


[Flag_Hippo]

Please attach those 500 hands you've played to a Support Ticket along with a link to this thread.