Run it twice - poker stars

[many12]

hello!
Can i do in poker tarcker 4 filtrs to spots when i played run it twice on cash games in poke stars?

thank you

[4StarGen]

There isn't a database field that contains that information. However when you replay a run it twice hand, PT4 displays all the boards so the data is stored somewhere. Maybe it could be a little complicated to extract, but i think it is doable. Let's see what PT4 is saying

[BillGatesIII]

For PokerStars this Filter Expression should work in a Hands Report.

Code: Select all

cash_hand_histories.id_hand = cash_hand_player_statistics.id_hand
and cash_hand_histories.history like '%Hand was run twice%'

[4StarGen]

Nice, I didn't think about HH's table.
Do you know whether expressions like yours works with tables outside PT4's std DB? i.e. can I make a join between a PT4's table and my custom view? (I'm not a home for 3 days so I cannot check it myself)

[many12]

For PokerStars this Filter Expression should work in a Hands Report.

Code: Select all

cash_hand_histories.id_hand = cash_hand_player_statistics.id_hand
and cash_hand_histories.history like '%Hand was run twice%'

can you tell me where should i copy it?

[WhiteRider]

Make a Hands report in My Reports; click the blue Filters link and choose 'expression filters' and you can add it there.

[BillGatesIII]

Nice, I didn't think about HH's table.
Do you know whether expressions like yours works with tables outside PT4's std DB? i.e. can I make a join between a PT4's table and my custom view? (I'm not a home for 3 days so I cannot check it myself)

Sure, but you'll have to rewrite the query a bit. For example, this piece of code gives the same result as the original.

Code: Select all

exists (
  select 1
  from cash_hand_histories as chh
  where chh.id_hand = cash_hand_player_statistics.id_hand
  and chh.history like '%Hand was run twice%')

Within the subquery you can use any table or view you want.

[4StarGen]

Wonderful, now I think I will be able to do the analysis I wanted to do in the other thread (filter hands based on player's actions and stats)

[4StarGen]

EDIT: I just tried and seems I'm lacking of SQL skillz, retrieving players' name in the hand report is easy, but their stats isn't