How Can I Filter To See Just The Pots I'm Knocked Out on

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

How Can I Filter To See Just The Pots I'm Knocked Out on

Postby phaze112 » Thu Oct 09, 2008 12:40 am

I want to see how the pots went that I am knocked out on is there a way to do this?

Thanks much,

Travis
phaze112
 
Posts: 14
Joined: Wed Oct 08, 2008 8:05 pm

Re: How Can I Filter To See Just The Pots I'm Knocked Out on

Postby WhiteRider » Thu Oct 09, 2008 7:54 am

You mean the hands you went bust on in a tournament?
There is no simple filter for this, but you could create a Custom Statistic to find hands where the amount you bet is equal to your stack before the hand and you lost the hand, and then create a Custom Report and filter for those hands using your new stat.

Custom Statistics and Reports FAQ.

Have a go at it, and if you get stuck please ask.

You will probably need database fields:
holdem_hand_player_detail.amt_before
holdem_hand_player_detail.amt_bet_ttl
holdem_hand_player_statistics.flg_won_hand
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 0 guests