Filter for hands with between x and y players

[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

[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

[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