problem filtering by board card in a report

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

problem filtering by board card in a report

Postby SaiYeN » Wed Oct 08, 2008 11:16 pm

Im trying to make a report in the "Holdem Cash Player Statistics" section and want to filter for different board cards. I'm using "holdem_hand_summary.card_1=13" as a filter and am getting a error: Unable to execute query...

I can use that filter fine under the "Holdem Cash Hand" section for but not under player statistics. Basically what i want to do is view a players stats on different board cards, ie cbet stats on Axx flops.

How can i get this to work?
SaiYeN
 
Posts: 34
Joined: Thu Jan 24, 2008 11:49 pm

Re: problem filtering by board card in a report

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

As you point out, you're trying to filter for something to do with specific hands in a report about players - that won't work.

I guess there are 2 ways to do this, neither particularly neat..
1. You could run a Hands report and use the column totals to view the over all totals
2. You could create custom stats in HCPS section and check for when the cards meet your criteria.

Having thought about this a little, I agree that you ought to be able to do this, since the "Simple Filters" will filter by hand.
I'll get the developers to have a look at this thread and see if there's anything we can do.
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 1 guest