PDA

View Full Version : PokerTracker


The Truth
07-21-2005, 01:19 AM
Say I want to run a real specific filter. For instance, I want to see every non-pair hand I raised out of the cut off after 1 limper. How would I go about filtering for this in PT? any ideas?

Fillamoore
07-21-2005, 02:00 AM
good question. Ive come into problems similar to this one...im not sure if there is in fact a way to be that specific...im curious to know...

Entity
07-21-2005, 02:01 AM
Talk to peter_rus and read the SQL forum at PokerTracker's forums. That should help a bit -- sorry I can't be of more help.

The Truth
07-21-2005, 02:05 AM
Looks like im going to have to learn to be an SQL database admin. The internet is telling me to take classes or something. Im gonna go buy a book. I'll give you a trip report and a book review in a couple days. Then, I guess i'll be able to run some good filters.

SpaceAce
07-21-2005, 05:01 AM
[ QUOTE ]
Looks like im going to have to learn to be an SQL database admin. The internet is telling me to take classes or something. Im gonna go buy a book. I'll give you a trip report and a book review in a couple days. Then, I guess i'll be able to run some good filters.

[/ QUOTE ]

I've never run any advanced filters in PokerTracker but if it accepts standard SQL queries, it shouldn't be tough to do what you want to do.

Briefly, you want something along the lines of:
SELECT * FROM [DATABASE NAME] WHERE [NAME OF SQL COLUMN FOR TYPE OF HAND]=[WORD OR PHRASE USED TO DESIGNATE NON-PAIR HANDS] AND [NAME OF SQL COLUMN FOR NEXT CRITERION]=[WHATEVER YOU'RE LOOKING FOR]

So, something like:
SELECT * FROM mydatabase WHERE handtype=nopair AND numopponents=1 AND whatever=whatever

Check out these resources:
http://www.w3schools.com/sql/
http://dev.mysql.com/doc/mysql/en/

Concentrate on the "SELECT" statement.

SpaceAce