Hand number, filter

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Hand number, filter

Postby 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

Re: Hand number, filter

Postby 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

Re: Hand number, filter

Postby BloMur » Mon Jul 05, 2021 11:33 am

Winamax has this number in hand number (picture)

https://imgur.com/a/TyaXfUI

fe . 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

Re: Hand number, filter

Postby 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

Re: Hand number, filter

Postby 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

Who is online

Users browsing this forum: No registered users and 30 guests

cron
highfalutin