new column "cnt_BB_v_SB_saw_t" not valid

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 "cnt_BB_v_SB_saw_t" not valid

Postby cheerful » Tue Jan 17, 2012 9:29 am

sorry, it's me again.

sum( if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_detail.val_p_raise_aggresor_pos = 9 AND holdem_hand_player_statistics.flg_t_saw, 1, 0])

not valid.
cheerful
 
Posts: 9
Joined: Mon Jan 16, 2012 9:28 pm

Re: new column "cnt_BB_v_SB_saw_t" not valid

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

"Agressor" has two ses - add an s and it will validate.
kraada
Moderator
 
Posts: 54430
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 2 guests