flag or value for say IP or OOP in report of Session-hand

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

flag or value for say IP or OOP in report of Session-hand

Postby marvin » Wed Sep 22, 2010 5:03 am

im tryng to customize the report of tag sessions-Sessions by table-session hands. i wish see on each row (that is refered to specific hand played on a particular table) if i was IP or OOP post flop (like the default flag of CCPF, BB or similar wuold be nice, but will be good also a strig like IP or OOP). how it is possible?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: flag or value for say IP or OOP in report of Session-hand

Postby kraada » Wed Sep 22, 2010 9:06 am

Unzip and import the stat I've attached to this post in the Configure --> Configure Statistics section. Once it's imported, click the little wrench next to your report, and add the new stat Has Position on Flop. The stat will show an empty check box if you saw the flop and were not in position. The box will have a check if you saw the flop and were in position. No box will show for hands you did not see the flop.
Attachments
Has Position on Flop.zip
(459 Bytes) Downloaded 92 times
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: flag or value for say IP or OOP in report of Session-hand

Postby marvin » Wed Sep 22, 2010 3:39 pm

format: if(flg_f_saw(format_bool(flg_f_has_position, 'check'))) expression: flg_f_has_position.it say: invalid operation specified in expression. i have imported it in hold em cash hand. the report where i have insert this flag contains this stat:
amount Won native, flag SB, flag BB, hole cards, flop, turn e river cards, pf action, f action, t action, r action, flop bet, river bet turn bet, final hand, winning hand, date, # hand.
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: flag or value for say IP or OOP in report of Session-hand

Postby kraada » Wed Sep 22, 2010 4:30 pm

What's it say in the flg_f_has_position column for you?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: flag or value for say IP or OOP in report of Session-hand

Postby WhiteRider » Thu Sep 23, 2010 2:49 am

if(flg_f_saw(format_bool(flg_f_has_position, 'check')))

..isn't complete. You only have one expression in the IF, and you're using flg_f_saw as if it is a function; it needs to be IF(expr,then,else).
So you need:

if(flg_f_saw,format_bool(flg_f_has_position, 'check'),''))
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: flag or value for say IP or OOP in report of Session-hand

Postby marvin » Thu Sep 23, 2010 5:42 am

kraada wrote:What's it say in the flg_f_has_position column for you?

after that i have imported your attached file, and inserted the stat in my report, the report doenst show flag, but the red written:
Expression: invalid operation specified in expression.

I HAVE TRIED TO MODIFY WHAT WAS IN THE ATTACHED FILE, INSERTING
if(flg_f_saw,format_bool(flg_f_has_position, 'check'),'')) like WR says, but if i try to save stat "has position on flop" (modified) it "say format expression is not valid"
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: flag or value for say IP or OOP in report of Session-hand

Postby kraada » Thu Sep 23, 2010 9:03 am

One more minor fix - the format expression should read:
if(flg_f_saw, format_bool(flg_f_has_position, 'check'), '')

Then it will work properly. I just tested it myself and it does function appropriately then.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: flag or value for say IP or OOP in report of Session-hand

Postby marvin » Thu Sep 23, 2010 6:14 pm

yes it works. TY!!
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 6 guests

cron