Report filter problem

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

Report filter problem

Postby Steeno69 » Mon Feb 22, 2010 6:41 pm

I would like to filter out the big winners and myself in a report. I tried with the following command in filter, which is not valid
Code: Select all
 
str_player_name='nameA' OR str_player_name='nameB'  OR str_player_name='nameC' OR #BB/100#>1.5

weird thing is that
Code: Select all
str_player_name='nameA' OR str_player_name='nameB'  OR str_player_name='nameC'

is valid, as is
Code: Select all
 #BB/100#>1.5


any idea why, and suggestions how to get this to work?
if this is the wrong forum feel free to move it
Steeno69
 
Posts: 10
Joined: Mon Oct 06, 2008 10:37 am

Re: Report filter problem

Postby kraada » Mon Feb 22, 2010 7:46 pm

I think you're having problems because you're mixing column descriptions and stats together.

Try replacing str_player_name with #Player# and see if that gets it to work.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report filter problem

Postby Steeno69 » Mon Feb 22, 2010 8:45 pm

tried this

Code: Select all
#BB/100#>1.5 OR #Player# = 'NameA' OR #Player#='NameB' OR #Player#='NameC'


Same result, both parts individually work, together it's not valid
Steeno69
 
Posts: 10
Joined: Mon Oct 06, 2008 10:37 am

Re: Report filter problem

Postby WhiteRider » Tue Feb 23, 2010 5:40 am

I can't see why that is - I'll report it to the development team.
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