Filter for Part of a Tablename?

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

Filter for Part of a Tablename?

Postby Olaf72 » Tue Nov 30, 2010 11:01 am

I'd like to filter for certain parts of Tablenames.
Is there a way to define a boolean-Column or Statistic in "Holdem Cash Session" if the Tablename contains the String "fast" or "ante" for example?

Greet
Olaf
Olaf72
 
Posts: 50
Joined: Fri Jan 30, 2009 10:29 am

Re: Filter for Part of a Tablename?

Postby kraada » Tue Nov 30, 2010 11:08 am

Not at this point in time, but features like these are planned for eventual future releases.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Filter for Part of a Tablename?

Postby WhiteRider » Tue Nov 30, 2010 11:26 am

Add a column with an expression like this:

holdem_table.table_name LIKE '%fast%'

You can then either add a stat to display that (e.g. as a checkbox) or use it in a custom filter in a custom report.
Tutorial: Custom Reports and Statistics
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