Creating Custom Filter for Betting and Raising Draws

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

Creating Custom Filter for Betting and Raising Draws

Postby mstef8 » Sun Jan 31, 2010 4:20 pm

Hey Everyone. Im Fairly new to PT3 but I love the program a lot and have been experimenting with some of its many features lately. One thing I started doing was creating filters for actions of the Players I have been playing against. I have had success narrowing down things that I think are important in order to review their hands and take some good notes.

One thing I am having trouble with is creating a filter for players that are capable of betting or raising a straight or flush draw on the Flop or Turn. Step by Step, I apply the site, then the action of "BET" then I apply the draws "OPEN ENDED STRAIGHT" & "ANY FLUSH" Its narrows down a range of players for me but when I click to look at their starting hands, there is nothing for anyone. Even my own stats.

What am I doing wrong here? How Can PT3 narrow the players down for me in my database as to having bet or raised on draw but not show the starting cards in which they were doing it with? Any help would be greatly appreciated.

Thanks
mstef8
 
Posts: 2
Joined: Fri Oct 02, 2009 9:34 pm

Re: Creating Custom Filter for Betting and Raising Draws

Postby WhiteRider » Sun Jan 31, 2010 5:06 pm

Make sure you have your ANDs and ORs in the right places. If you have everything ANDed together then all the cases need to be true, and you can sometimes end up with an expression that can't possibly be true.
Tutorial: Filters
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Creating Custom Filter for Betting and Raising Draws

Postby mstef8 » Sun Jan 31, 2010 10:07 pm

Would you be able to give me an example of what it would look like? Im no whiz with databases here :?:
mstef8
 
Posts: 2
Joined: Fri Oct 02, 2009 9:34 pm

Re: Creating Custom Filter for Betting and Raising Draws

Postby kraada » Mon Feb 01, 2010 9:34 am

Could you tell me exactly what the filter expression is that you're seeing on the Filters window?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests