specific tournament reports

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

specific tournament reports

Postby broccoli » Fri Nov 07, 2008 10:27 pm

Hello,

I would like to run reports on a specific tournament (for example, tournament #444444 in PokerStars). The stats I need are in Holdem Tournament Hand. But I don't know how to specify the tournament there. I guess I could specify a range of hand numbers, but that's too tedious. There is a filter field in HTH called "id_tourney", but that does not seem to work with the tournament number values I get from PokerStars. In Holdem Tournament Tournament there is a stat TourneyNo, which does have the values that I would like to filter on. But I don't know how to filter on those values in HTH. Does anyone know how that can be done?

Btw, I'm brand new to report running,

Thanks.
broccoli
 
Posts: 6
Joined: Sat Apr 12, 2008 12:59 am

Re: specific tournament reports

Postby broccoli » Sat Nov 08, 2008 1:09 am

I answered my own question. I added this custom column and statistic to the Holdem Tournament Hand section:

tourney_holdem_summary.tourney_no

Cool, my first custom statistic...

Thanks.
broccoli
 
Posts: 6
Joined: Sat Apr 12, 2008 12:59 am

Re: specific tournament reports

Postby kraada » Sat Nov 08, 2008 9:50 am

Congratulations! :D
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 14 guests

cron
highfalutin