Create report within application that looks at ALL players

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

Create report within application that looks at ALL players

Postby DalTXColtsFan » Fri Oct 26, 2012 8:12 pm

Hello,

Within the application, is it possible to create a report showing where ANY player performed a certain action, for example,

- show me all of MY hands where ANY PLAYER IN THE HAND limp-called, or
- where ANY PLAYER IN THE HAND flatted a 3-bet, or
- where ANY PLAYER IN THE HAND check-rasied the flop

I can only figure out how to do this for one villain at a time.

Help will be appreciated!

If this can't be done in the application can it be done by querying one of the back-end tables directly?
DalTXColtsFan
 
Posts: 8
Joined: Tue Aug 07, 2012 2:46 pm

Re: Create report within application that looks at ALL playe

Postby kraada » Fri Oct 26, 2012 10:49 pm

If you create a custom report on the Reports tab you can go into the blue Filters link and uncheck "Filter on Active Player" - that will remove the restriction that the data can only come from one player. This might mean depending on how your report that a hand could come up multiple times - up to once per player in the hand. It sounds like this will give you the ability to do what you want - then you can filter for hands where anybody limp/called using the Simple Filters options and the limp/calling will apply to anyone in the hand, not just you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Create report within application that looks at ALL playe

Postby DalTXColtsFan » Sat Oct 27, 2012 2:29 pm

Found it - thank you! I had to really hunt but I found it. I had to create a hand report, then click filters/add new expression filters. That's where I can uncheck filter on active player.

From there the filters work as you described.

THANK YOU!
DalTXColtsFan
 
Posts: 8
Joined: Tue Aug 07, 2012 2:46 pm


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

Who is online

Users browsing this forum: No registered users and 2 guests