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 mtagliaf » Sun Aug 16, 2009 2:40 pm
I am trying to come up with a way to write a query that shows me how many chips I have in a 9 man SNG immediately after the bubble breaks - that is, the first hand that there are three players at the table.
Is there a way to do this?
-
mtagliaf
-
- Posts: 45
- Joined: Tue Feb 12, 2008 10:30 pm
by WhiteRider » Sun Aug 16, 2009 3:00 pm
Each hand is stored in the database indepedently, so this isn't easy.
Someone was asking about something like this before and I think that Kradda did some work on it, although I'm not sure that it was possible. I'm sure he'll get back to you tomorrow but I think he's off for the rest of today.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by mtagliaf » Sun Aug 16, 2009 9:28 pm
I can do this outside of PT3 if I can get an export from a custom report with the following info:
Tourney #
Date/Time (so I can sort in order)
Chips
Then I can filter where Players at table=3, and export.
the problem is that tourney# doesn't seem to be available in a "Holdem Tournament Hand" report. Can you join a report of type "Holdem Tournament Hand" to get columns in "Holdem Tournament Tournament"?
-
mtagliaf
-
- Posts: 45
- Joined: Tue Feb 12, 2008 10:30 pm
by WhiteRider » Mon Aug 17, 2009 4:24 am
You could use the database field "tourney_holdem_hand_summary.id_tourney" to find the tournament ID for a hand.
-
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