Tourney id

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

Tourney id

Postby krewer » Tue Jan 17, 2012 7:05 am

Hi. I have created a report in the "Holdem Tournament Hand" section. I have set it up to filter for hands I have marked for review. Is it possible to add a "TourneyNo" to the stats in the report?
krewer
 
Posts: 13
Joined: Wed Jun 24, 2009 12:38 pm

Re: Tourney id

Postby kraada » Tue Jan 17, 2012 9:15 am

Yes, though you'll need to create it.

Thankfully it's very easy to create.

Click Configure --> Configure Stats, click Holdem Tournament Hand and go to the Columns tab. Click New, give your column a name (I'll use tourney_no but you can call it something else if you'd like so long as you're consistent).

Give it the expression: tourney_holdem_summary.tourney_no - summary type Count is good and you can add any description you'd like (though you don't need to). Click on the Statistics tab. Click New. Give your stat a Name and Description. In the Value Expression enter tourney_no, and click on the Format tab. Give it a title (Tourney # would work well) and a width (something like 80), and save your stat. Once you click Apply, ou can now add it to any Hand report you'd like.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Tourney id

Postby krewer » Tue Jan 17, 2012 5:26 pm

Thanks for the help. It worked like a charm.
krewer
 
Posts: 13
Joined: Wed Jun 24, 2009 12:38 pm


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

Who is online

Users browsing this forum: No registered users and 2 guests