Check raise results

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

Check raise results

Postby raistlinx » Tue Sep 02, 2008 1:46 pm

I am trying to filter my hands to review those hands in which I faced a check raise on the turn.

Currently my filter is: "Any Turn Bet And Facing Raise on Turn" but this of course gives me hands I was OOP as well. I can't find another filter setting to indicate I was facing a check followed by a raise (from that same player).

Is that feature in development or is there a way to filter for it currently?
raistlinx
 
Posts: 19
Joined: Wed May 14, 2008 2:44 pm

Re: Check raise results

Postby WhiteRider » Wed Sep 03, 2008 7:50 am

No, you're right, this can't yet be done with Standard filters, but you can build a Custom Statistic to show check-raises.

I thought I had a custom stat that included check-raise logic, but I can't find it just now.
Have a go at building one yourself, and if you get stuck, ask.
Here are a few database fields you might need, to get you started.

holdem_hand_player_detail.flg_t_has_position
holdem_hand_player_statistics.flg_t_bet
holdem_hand_player_statistics.flg_t_face_raise

See the Custom Stats Documentation and the Custom Statistics and Reports FAQ.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Check raise results

Postby raistlinx » Wed Sep 03, 2008 11:16 am

These three DB fields seemed to be sufficient since I am only creating a filter. So I first created a column under Holdem Cash Hand

http://www.celticchef.com/musings/files/1.JPG

I then added this column as a filter to a custom report

http://www.celticchef.com/musings/files/2.JPG

However when I run this report (which currently has only one field, "Hand #") I get no data returned so I must be mising a step. Any advice?
raistlinx
 
Posts: 19
Joined: Wed May 14, 2008 2:44 pm

Re: Check raise results

Postby raistlinx » Wed Sep 03, 2008 12:10 pm

Maybe a mod could move this thread to the correct forum?
raistlinx
 
Posts: 19
Joined: Wed May 14, 2008 2:44 pm

Re: Check raise results

Postby WhiteRider » Wed Sep 03, 2008 3:06 pm

Firstly, and trivially, I assume you use bln_ for boolean? This is fine, obviously, but the naming convention is flg_ for 'flag'.

You don't need the IF statement, you can just use the rest of the statement and have the value as a true or false value, then in your filter, you can just check for "bln_t_cred" (or flg_t_cred) rather than "bln_t_cred = 1".

All that said, there's definitely something going on here, I've just tried building this and it's not working right.
I'm going to create a ticket about this.
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 2 guests