Report identifying sitting out hands

[afteRReset]

Is there a way to filter pokerstars sitout hands?
Here's one sample of a hand

Spoiler: show

PokerStars Hand #24610111329: Tournament #36482675, $9.59+$0.41 USD Hold'em No Limit - Level VII (60/120) - 2023/09/21 16:33:35 ET
Table '3648203675 1' 6-max Seat #4 is the button
Seat 4: player (2356 in chips)
Seat 6: player (644 in chips) is sitting out
player: posts the ante 12
player: posts the ante 12
player: posts small blind 60
player: posts big blind 120
*** HOLE CARDS ***
Dealt to player [Js 3d]
player: raises 120 to 240
player: folds
Uncalled bet (120) returned to player
player collected 264 from pot
player: doesn't show hand
*** SUMMARY ***
Total pot 264 | Rake 0
Seat 4: player (button) (small blind) collected (264)
Seat 6: player (big blind) folded before Flop

[Flag_Hippo]

That information isn't stored in the database so there isn't a built-in filter but you can use a custom filter to search for specific text in the hand history - see this thread. The example is for hands run twice but the principle is the same.

[afteRReset]

That information isn't stored in the database so there isn't a built-in filter but you can use a custom filter to search for specific text in the hand history - see this thread. The example is for hands run twice but the principle is the same.

Thank you. Could you please suggest what tournament hand alternative would look like? Or where could I look for those tables and columns for tournaments in pt4 database

Code: Select all

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

[Flag_Hippo]

Substitute cash with tourney and replace Hand was run twice with the text you want to search for:

Code: Select all

tourney_hand_histories.id_hand = tourney_hand_player_statistics.id_hand and tourney_hand_histories.history like '%is sitting out%'

Bear in mind that this filter isn't player specific. If you want something player specific you will need to include the player name and wildcard the possible variations in the chip value length that can be between the player name text and the sitting out text. For more information on pattern matching in PostgreSQL see this guide.

[afteRReset]

Substitute cash with tourney and replace Hand was run twice with the text you want to search for:

Code: Select all

tourney_hand_histories.id_hand = tourney_hand_player_statistics.id_hand and tourney_hand_histories.history like '%is sitting out%'

Bear in mind that this filter isn't player specific. If you want something player specific you will need to include the player name and wildcard the possible variations in the chip value length that can be between the player name text and the sitting out text. For more information on pattern matching in PostgreSQL see this guide.

It would be 4 characters max, as I play sngs and stack doesn't get more than 3000. I am not very regex-savy, how do I limit the amount of characters beetween two texts? Needs to be something like this

Code: Select all

 '%Player%{1,4}in chips) is sitting out%'

but it doesn't really work, something wrong with syntax
So far without limitation this works semi-fine but includes some other players sitting out

Code: Select all

tourney_hand_histories.id_hand = tourney_hand_player_statistics.id_hand and tourney_hand_histories.history like '%Player%in chips) is sitting out%'

[Flag_Hippo]

You can use underscores as a wildcard for any character:

Code: Select all

tourney_hand_histories.id_hand = tourney_hand_player_statistics.id_hand and (tourney_hand_histories.history like '%afteRReset (___ in chips) is sitting out%' or tourney_hand_histories.history like '%afteRReset (____ in chips) is sitting out%')

[WhiteRider]

This is an alternative that will work for any number between 1 and 4 digits:

Code: Select all

tourney_hand_histories.id_hand = tourney_hand_player_statistics.id_hand and tourney_hand_histories.history SIMILAR TO '%\(\d{1,4} in chips\) is sitting%'

\d is any digit, but you could use _ for any single character too.
Note that we use "similar to" instead of "like" for full regex queries.