filter tournaments by name or by part of name

Let us know what features not currently in the PT4 should be added.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

filter tournaments by name or by part of name

Postby jacques » Sat Aug 09, 2014 5:16 pm

Hi there, i would like to suggest a new filter for tourament : the name or a part of a name... as an exemple on winamax we have so called tournament "xtra" "xpert" or mtt 180 max (this one came with differents buy-in) and it can be interresting to filter on those name (or part of it like "180". wildcards should be a plus ( *, % , _ , ? )
jacques
 
Posts: 62
Joined: Wed Oct 03, 2012 1:59 pm

Re: filter tournaments by name or by part of name

Postby kraada » Sun Aug 10, 2014 7:47 am

You can do this via the My Reports area in the Filter Expressions area as you can filter for any data based on direct SQL there. I think the information you'll want to filter on will be in tourney_table.table_name.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: filter tournaments by name or by part of name

Postby jacques » Sun Aug 10, 2014 8:36 am

greattt it works :)
jacques
 
Posts: 62
Joined: Wed Oct 03, 2012 1:59 pm

Re: filter tournaments by name or by part of name

Postby jacques » Sun Aug 10, 2014 8:57 am

arf in facr the results are weirdly displaying duplicates lines... any id of what happens? my sql request is : str_tourney_table like '%180%'
Attachments
weirdyreport.JPG
jacques
 
Posts: 62
Joined: Wed Oct 03, 2012 1:59 pm

Re: filter tournaments by name or by part of name

Postby kraada » Sun Aug 10, 2014 9:18 am

Do you have Filter on Active Player off? If you did that you'd see one row per tournament per player in the tournament and thus quite a bit of duplication.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: filter tournaments by name or by part of name

Postby jacques » Tue Aug 12, 2014 2:29 pm

there is no lines if select active playr is on... and duplicate if it is off.... :(
jacques
 
Posts: 62
Joined: Wed Oct 03, 2012 1:59 pm

Re: filter tournaments by name or by part of name

Postby kraada » Tue Aug 12, 2014 2:46 pm

Try this filter expression and let me know if it works better:
tourney_table.table_name LIKE '%180%'
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: filter tournaments by name or by part of name

Postby jacques » Wed Aug 13, 2014 4:39 am

I am affraid to say it don't works
jacques
 
Posts: 62
Joined: Wed Oct 03, 2012 1:59 pm

Re: filter tournaments by name or by part of name

Postby kraada » Wed Aug 13, 2014 7:40 am

Do you get any data then?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: filter tournaments by name or by part of name

Postby jacques » Wed Aug 13, 2014 9:39 am

still duplicating :/
Attachments
duplicate.JPG
jacques
 
Posts: 62
Joined: Wed Oct 03, 2012 1:59 pm

Next

Return to PT4 Feature Requests

Who is online

Users browsing this forum: No registered users and 7 guests

cron