Custom Query Question

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

Custom Query Question

Postby amre » Sat Nov 29, 2008 1:34 am

Hi,
I was wondering if it was possible using pt3 to build a report, custom filter for the players menu, or if those dont work some kind of hack or workaround to do the following. For all hands played on a specific day by ALL players in the db, each individual hh is processed to list the names of each player in the hand and the amount of money they won or lost in the hand. I'd want the whole thing exportable in w/e format. I'm willing to work hard to learn how to code this; but I wanted to see if the software could do it before I invested a lot of time. If you have expertise, please enlighten me!
Thanks very much!
amre
 
Posts: 6
Joined: Sat Nov 29, 2008 1:28 am

Re: Custom Query Question

Postby WhiteRider » Sat Nov 29, 2008 5:50 am

You want to know how much each player won/lost in every hand played on a certain day?

This is very easy, but be aware if there are a lot of hands on that day it will be a very big report (number of rows = number of players per table * number of hands) so make sure you set it up right before you run it - if you miss the date filter for instance it will take AGES.

Go the the Reports tab and choose the Holdem Cash Hands Section.
Name your report.
Add the Player and Amount Won stats by double clicking them in the list. (add any other stats you want too, like Hand#..)
Click the 'Filters' link in the report config area (NOT the main Filters button).
Uncheck 'Filter on Active Player'.
Click the Simple Filters button and add your date filter, top left of the filters window.
Save the report, and run it.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom Query Question

Postby amre » Sat Nov 29, 2008 8:45 pm

Wow, thanks, you are awesome. You just sold another piece of software.
amre
 
Posts: 6
Joined: Sat Nov 29, 2008 1:28 am

Re: Custom Query Question

Postby WhiteRider » Sun Nov 30, 2008 6:11 am

You're welcome.

And I forgot to say, if you want to export the report data, click the 'Expand' (4-arrow) icon to the right of the report then you can use the 'Export' button so save it to file.
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 7 guests