Report identifying sitting out hands
Posted: Thu Sep 21, 2023 5:44 pm
PokerTracker
https://de.pokertracker.com/forums/
Report identifying sitting out hands
https://de.pokertracker.com/forums/viewtopic.php?f=61&t=103177
Page 1 of 1
Posted: Thu Sep 21, 2023 5:44 pmRe: Report identifying sitting out hands
Posted: Fri Sep 22, 2023 5:45 amThat 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.
Re: Report identifying sitting out hands
Posted: Sat Sep 23, 2023 6:04 amFlag_Hippo wrote: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%'
Re: Report identifying sitting out hands
Posted: Sat Sep 23, 2023 12:13 pmSubstitute cash with tourney and replace Hand was run twice with the text you want to search for:
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.
- 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.
Re: Report identifying sitting out hands
Posted: Sat Sep 23, 2023 5:57 pmFlag_Hippo wrote: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%'
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%'
Re: Report identifying sitting out hands
Posted: Sun Sep 24, 2023 5:17 amYou 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%')
Re: Report identifying sitting out hands
Posted: Mon Sep 25, 2023 4:07 amThis is an alternative that will work for any number between 1 and 4 digits:
\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.
- 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.
