Query to Custom Stats

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

Query to Custom Stats

Postby TROM » Sat Nov 06, 2010 12:46 am

If I create my own stat can I make query to this stat from another prorgram not pokertraker by SQL?
TROM
 
Posts: 57
Joined: Mon Jun 16, 2008 6:56 pm

Re: Query to Custom Stats

Postby WhiteRider » Sat Nov 06, 2010 5:37 am

Not directly - the stat value isn't stored in the database, but once you have updated the cache the column values are stored (in the "holdem cache" table, for instance) so you could retrieve those and calculate the stat value outside PT3.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Query to Custom Stats

Postby TROM » Sat Nov 06, 2010 10:28 pm

thanks
now I understand new stats only for pokertraker but new column store in database

But what about Export I dont undersand logic
I want to save my new column and stats
But for column I dont have export button
and dont know what exactly exports when I do it for new stats all new column what I use in this stat too ?
TROM
 
Posts: 57
Joined: Mon Jun 16, 2008 6:56 pm

Re: Query to Custom Stats

Postby WhiteRider » Sun Nov 07, 2010 5:53 am

When you export a stat any columns or variables it uses are exported too.
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