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
by 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
by 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
by 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
by 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]
Users browsing this forum: No registered users and 0 guests