Filtering out myself

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

Filtering out myself

Postby pasita » Thu Dec 02, 2010 12:53 pm

Can I set up a report filter (running a report on Holdem Cash Player Statistics) that excludes a certain player, most likely that being myself.

If I do
#Player# != "mynick"
it won't validate.
pasita
 
Posts: 605
Joined: Tue May 06, 2008 4:05 pm

Re: Filtering out myself

Postby kraada » Thu Dec 02, 2010 1:45 pm

There's a known issue with that filter. I believe if you do it instead as player.player_name_real != 'mynick' it will work though.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Filtering out myself

Postby pasita » Thu Dec 02, 2010 1:52 pm

Won't validate, but player.player_name != 'mynick' works. Thanks.
pasita
 
Posts: 605
Joined: Tue May 06, 2008 4:05 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests