Page 1 of 1

Filter for hands with between x and y players

PostPosted: Wed Mar 05, 2008 2:27 pm
by maxp1981
Alright, so I do a report to generate a SQL.statement. But somehow i am missing a filter for players involved in the hand, where can I find it. Or how to change the SQL to filter for that ?

Thanks in advance

Max

Re: Filter for hands with between x and y players

PostPosted: Wed Mar 05, 2008 2:44 pm
by APerfect10
The information that you need is in the 'holdem_hand_summary' table and the field is 'cnt_players'

So your where clause would be:

WHERE ... (holdem_hand_summary.cnt_players >= X AND holdem_hand_summary.cnt_players <= Y)

Best regards,

Derek

Re: Filter for hands with between x and y players

PostPosted: Wed Mar 05, 2008 2:45 pm
by APerfect10
One little tip, if you ever need to know the SQL of a PokerTracker window or filter, you can view it in the PokerTracker.log file located in your main PokerTracker 3 directory...

Best regards,

Derek