New Column in Tournaments Tab

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

New Column in Tournaments Tab

Postby R3mbrandt » Sat Jan 31, 2009 1:02 pm

Hi all!

I'm new to the custom stats feature of PT3 and wondering, if it's possible to insert a new column in the "Tournaments Tab" right after "$/Hour" which displays the number of played and won hands.
Just "showing the way" to do this would be great!

Thx for your help!

R3mbrandt
R3mbrandt
 
Posts: 15
Joined: Fri Sep 12, 2008 4:17 pm

Re: New Column in Tournaments Tab

Postby kraada » Sat Jan 31, 2009 1:05 pm

Click the spanner/wrench icon at the top right of that report and double click a stat from the left column to add it to the report. Likewise double clicking it on the right will remove it from the report.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: New Column in Tournaments Tab

Postby R3mbrandt » Sat Jan 31, 2009 1:09 pm

Okay, that is not the problem. The problem is, the stats I'm interesting in, are not available - so I've to create my own. And here begin my problems - all trials end up, with a "never ending population" of this report. :-(
R3mbrandt
 
Posts: 15
Joined: Fri Sep 12, 2008 4:17 pm

Re: New Column in Tournaments Tab

Postby kraada » Sat Jan 31, 2009 1:37 pm

What stat are you trying to build?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: New Column in Tournaments Tab

Postby R3mbrandt » Sat Jan 31, 2009 1:48 pm

Just the number of hands played in the whole tournament and the number of hands won by hero.
I found this field in another table (holdem_table_session_summary.cnt_hands) but i'm not clever enough to bild a stat from this, which i can use as a new column in this report. ;-)
R3mbrandt
 
Posts: 15
Joined: Fri Sep 12, 2008 4:17 pm

Re: New Column in Tournaments Tab

Postby kraada » Sat Jan 31, 2009 2:06 pm

That database field is for cash games. All tourney fields start with tourney_

The stats you can put in that area are somewhat limited, as you can't access specific hand data, and as far as I can tell the number of hands in a tourney aren't stored in the tourney_holdem_results table, which means this likely isn't actually possible at this time.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: New Column in Tournaments Tab

Postby R3mbrandt » Sat Jan 31, 2009 2:24 pm

Thank you for clarifying this! Maybe these stats will be available in the future...? :-)
R3mbrandt
 
Posts: 15
Joined: Fri Sep 12, 2008 4:17 pm

Re: New Column in Tournaments Tab

Postby kraada » Sat Jan 31, 2009 2:43 pm

There are plans to expand the stat creation system to allow arbitrary SQL queries. I'm not sure how soon that's going to happen but once it does, this information will be available.
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 18 guests

cron
highfalutin