Hands number

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

Hands number

Postby tonixart » Fri Nov 27, 2009 11:50 pm

Hello! Is it possible to add number of played hands in "Tornaments - By Tournament" report as it is in cash sessions section?
Thank you.
tonixart
 
Posts: 46
Joined: Fri Sep 11, 2009 10:04 am

Re: Hands number

Postby kraada » Sat Nov 28, 2009 10:01 am

I'm not certain if that's possible, actually, but I'll look into it.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Hands number

Postby WhiteRider » Mon Nov 30, 2009 3:34 pm

Yes - the expression I have in my cnt_hands column is this:

SELECT count(*) FROM tourney_holdem_hand_player_statistics thhs_cnthands WHERE (thhs_cnthands.id_tourney = tourney_holdem_summary.id_tourney AND thhs_cnthands.id_player_real = player_real.id_player)

Tutorial - Custom Reports and Statistics
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 0 guests