How do you find a specific hand in the database?

[GrassNinja]

If I have the hand # (but don't have the date it was played), I want to be able to quickly find that hand (by hand # only) in the database and hopefully replay it in the playback window...I might be stupid and missing something obvious, but I can't figure it out. Thank you to any helpful guidance in advance.

[kraada]

Do you have any other data about the hand? If you knew, for example, who played in it and what cards they held, it would help a lot. You'd go to the Hands tab for that player, select the starting hand they had and sort the bottom report by hand number (click a column to sort) then scroll to the number you want and double click the hand.

[WhiteRider]

Otherwise you'll need to create a Custom Report and include the Hand # stat, or add a custom filter in your report to that hand number.
Tutorial - Custom Reports and Statistics

[doco]

Code: Select all

SELECT
    hhs.*
FROM
    holdem_hand_summary hhs
WHERE
    hhs.hand_no = 34457318254


Just playing around trying to think of a clever way to answer the posters question and discovered an interesting anomaly. Then again maybe its just me. From the query above I am looking at two fields in the resultset: date_played & date_imported. I then went to PT3 to
1. [ Sessions ] tab
2. [ Clear ] to remove any filters
3. [ Display ] DropDown --> Sessions by Time
4. Sort by [ Start Time ] in the [ Sessions by Time ] matrix.
The resultset for the random hand I used for criteria in my script, returned a date_played == "2009-10-25 00:02:19". Interestingly, the date, doesn't show up in PT3 at all; yet, it is in the DB. Rather odd don't you think?

[kraada]

Is that date played during the time of another session? The date played data is taken from the hand history at import time.

[doco]

Is that date played during the time of another session? The date played data is taken from the hand history at import time.

Just making the assumption if there are two associate attributes in the same rowset, hand_no & date_played being two of many; then hand_no must be 1:1 to date_played, regardless of when the data was downloaded?

[WhiteRider]

Yes, each hand can only be played at one time.
What I assume Kraada was implying is that the Sessions By Time report merges overlapping sessions, so you won't necessarily see the start time of a particular table-session in that report.
If you're looking in the Session Hands report, then you should of course see the start time of every hand in that session - make sure you are sorting by time or hand number, though, so that you're looking in the right place.
If you don't see it in Sessions by Time, do you see it in Sessions by Table?

[doco]

If you don't see it in Sessions by Time, do you see it in Sessions by Table?

Not there either. Wierd.

[WhiteRider]

Do you see the hands either side of it in the hand history file?
Can you see it in any of the other reports?

[doco]

Code: Select all

select
    hh.*,
    hhs.hand_no,
    hhs.date_played,
    player.id_player,
    player.player_name,
    det.seat,
    ( select c.hole_cards
      from lookup_hole_cards c
      where c.id_holecard = det.holecard_1 ) as hole_card_1,
    ( select c.hole_cards
      from lookup_hole_cards c
      where c.id_holecard = det.holecard_2 ) as hole_card_2
from
    holdem_hand_histories hh INNER JOIN
    holdem_hand_summary hhs ON
    hh.id_hand = hhs.id_hand INNER JOIN
    holdem_hand_player_detail det ON
    hh.id_hand = det.id_hand INNER JOIN
    player ON
    det.id_player = player.id_player
where
    player.player_name = 'astrodon'
and hhs.hand_no = 34457318254
order by hand_no


Ok, I am trying to ferret out ways of identifying the hand other than by hand_no. Which BTW, I was surprised to see hand_no is only found in one 'holdem%' table. Don't know why but I just was expecting to see it more. Anyway, something else that surprised me as I am beginning to get better familiar with the data. In the holdem_hand_details table there are two columns named [ holecards_1 ] and [ holecards_2 ]. I full expected this to return one individual card for holecards_1 and one individual card for holecards_2. What I am seeing is two complete hole card sets. In this case A8o & A4o respectively. Don't know exactly what this is supposed to be telling me?

Thread has got a little far afield from posters question but am really trying to discover how to help answer the posters question and whiterider's question to me.

BTW. I did find the hand by copying the contents of the hh.history field into Notepad and it gave me the hand I had at the time A9o ( which wasn't either one of the holecards listed). Then I found it in the [ Hands ] tab.