Filtering out all allin hands

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Filtering out all allin hands

Postby jjyet » Wed Sep 12, 2012 12:06 am

Hey guys,

I was wondering if there was a way to filter out all the hands that either one of the players is all in.
I messed around with
holdem_hand_player_statistics.enum_face_allin != 'R'
which I could then add another filter for the preflop flop and turn.
Unfortunately this doesn't eliminate the hands where the hero goes all in.
It only filters out hands where the hero faces an allin...

Thanks,
Josh
jjyet
 
Posts: 17
Joined: Fri Feb 29, 2008 3:28 am

Re: Filtering out all allin hands

Postby WhiteRider » Wed Sep 12, 2012 3:02 am

You can do that in the normal filters window - "Raise All-in" is on the Actions tab and "Face all-in" is on the Facing tab. If you add all of the all-in filters and 'NOT' them it will rule out all all-in hands.

See the Tutorial: Filters for more information on combining filters.

In terms of database fields you can use:

holdem_hand_player_statistics.enum_allin = 'N'

..which means the player didn't go all-in. Possible values are 'N' for 'none', or P, F, T, R for preflop, flop, turn, river.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Filtering out all allin hands

Postby jjyet » Wed Sep 12, 2012 2:02 pm

Great! Thanks a lot I used the simple filters and was able to remove all the times the hero raised all in

Thanks WhiteRider!
jjyet
 
Posts: 17
Joined: Fri Feb 29, 2008 3:28 am


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 7 guests