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 majonyjony » Mon Jan 10, 2011 2:29 pm
I create this column
sum(if[holdem_hand_player_statistics.flg_p_3bet, holdem_hand_player_detail.val_p_raise_made_pct
, 0])
But not correct,
Is posible to create this?
-
majonyjony
-
- Posts: 116
- Joined: Wed Oct 08, 2008 4:01 am
by kraada » Mon Jan 10, 2011 2:40 pm
I just tested and "sum(if[holdem_hand_player_statistics.flg_p_3bet, holdem_hand_player_detail.val_p_raise_made_pct, 0])" validated for me after I removed your extra return. Or do you mean the numbers are not working properly?
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by majonyjony » Mon Jan 10, 2011 2:53 pm
The problem is when I create a stat
(3BET_suma* / cnt_p_3bet )
*sum(if[holdem_hand_player_statistics.flg_p_3bet, holdem_hand_player_detail.val_p_raise_made_pct, 0])
No funciona in general tab-player statistics.
"Unable to execute query....."(too long)
-
majonyjony
-
- Posts: 116
- Joined: Wed Oct 08, 2008 4:01 am
by kraada » Mon Jan 10, 2011 2:56 pm
I believe column names need to start with alphabetic characters (ie- not numbers) in order to function properly. If you change your column name does it work then?
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by majonyjony » Mon Jan 10, 2011 3:43 pm
Yes, its OK.
TY Kraada!
-
majonyjony
-
- Posts: 116
- Joined: Wed Oct 08, 2008 4:01 am
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests