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 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
by 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
by 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]
Users browsing this forum: No registered users and 0 guests