Last 10K hands for player

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

Last 10K hands for player

Postby TROM » Mon Sep 19, 2011 4:55 am

I want all stats for player only for last 10K hands
How in SQL write query for PT3

I need to know what write after WHERE in query
TROM
 
Posts: 57
Joined: Mon Jun 16, 2008 6:56 pm

Re: Last 10K hands for player

Postby kraada » Mon Sep 19, 2011 2:12 pm

Where exactly are you using this filter - in a custom report?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Last 10K hands for player

Postby TROM » Mon Sep 19, 2011 5:44 pm

no i dont use custom report
i write sql query to the PT3 data base and want get only last 10.000 hands for each player
TROM
 
Posts: 57
Joined: Mon Jun 16, 2008 6:56 pm

Re: Last 10K hands for player

Postby WhiteRider » Tue Sep 20, 2011 3:41 am

If you enable logging and restart PT3, and set the "Last X Hands" option in the HUD Options and play a hand you will be able to see the database queries used in the PokerTracker.log file.
See the Tutorial: Submitting a Bug Report for help with logging, if you need it.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests