Filter by specific hands/hands with notes.

General discussion of PokerTracker 3.

Moderator: Moderators

Filter by specific hands/hands with notes.

Postby DEfusion » Fri Aug 26, 2011 8:31 am

I'd love to know if it's possible to filter by specific hands (e.g. a list of hand numbers) or at worst hands with notes. I'm perfectly at home with SQL but can't find a way to add custom filters the way you can add custom stats.

At worst I imagine I could duplicate the database in PostgreSQL and either filter while doing the duplication (I know you can do backups with a select in MySQL) or delete all records that don't have a note but I haven't looked at the database structure yet - but being able to do this in the UI would be best.
DEfusion
 
Posts: 28
Joined: Fri Aug 26, 2011 8:25 am

Re: Filter by specific hands/hands with notes.

Postby kraada » Fri Aug 26, 2011 9:13 am

You can do this in the custom reports - as you're familiar with SQL it will help to know that anything in the blue Filters link in the custom report will get put into the WHERE clause of the SQL query that is generated.

Also, hands with notes are the same as marked hands, so you can follow this tutorial to build a custom report to show all and only noted hands.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Filter by specific hands/hands with notes.

Postby DEfusion » Fri Aug 26, 2011 9:21 am

Thanks kraada, that's perfect - exactly what I was looking for.
DEfusion
 
Posts: 28
Joined: Fri Aug 26, 2011 8:25 am


Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests