Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by BloMur » Mon Jul 05, 2021 6:53 am
Is it possible to sort hands by what is hand number in tournament.
Fe. filter only first hands in tournament
-
BloMur
-
- Posts: 49
- Joined: Fri Nov 24, 2017 7:47 pm
by Flag_Hippo » Mon Jul 05, 2021 11:25 am
Unfortunately I don't know of a method to do that or even if this type of query is even possible.
-
Flag_Hippo
- Moderator
-
- Posts: 14441
- Joined: Tue Jan 31, 2012 7:50 am
by BloMur » Mon Jul 05, 2021 11:33 am
Winamax has this number in hand number (picture)
https://imgur.com/a/TyaXfUIfe . ending 00007 means 7th hand in tournament
But i dont know how to sort it out
-
BloMur
-
- Posts: 49
- Joined: Fri Nov 24, 2017 7:47 pm
by Flag_Hippo » Mon Jul 05, 2021 12:05 pm
You can filter for a specific sequence within hand numbers with an expression filter like this:
- Code: Select all
tourney_hand_summary.hand_no LIKE '_________00001'
Make sure to leave the single quotes and you can add additional ORs as required to filter for more hand numbers or edit the filter further as required. For more information on pattern matching in PostgreSQL see
this guide.
-
Flag_Hippo
- Moderator
-
- Posts: 14441
- Joined: Tue Jan 31, 2012 7:50 am
by BloMur » Mon Jul 05, 2021 12:15 pm
It works!
Thank alot
-
BloMur
-
- Posts: 49
- Joined: Fri Nov 24, 2017 7:47 pm
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 25 guests