Page 1 of 2
filter tournaments by name or by part of name

Posted:
Sat Aug 09, 2014 5:16 pm
by jacques
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 ( *, % , _ , ? )
Re: filter tournaments by name or by part of name

Posted:
Sun Aug 10, 2014 7:47 am
by kraada
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.
Re: filter tournaments by name or by part of name

Posted:
Sun Aug 10, 2014 8:36 am
by jacques
greattt it works :)
Re: filter tournaments by name or by part of name

Posted:
Sun Aug 10, 2014 8:57 am
by jacques
arf in facr the results are weirdly displaying duplicates lines... any id of what happens? my sql request is : str_tourney_table like '%180%'
Re: filter tournaments by name or by part of name

Posted:
Sun Aug 10, 2014 9:18 am
by kraada
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.
Re: filter tournaments by name or by part of name

Posted:
Tue Aug 12, 2014 2:29 pm
by jacques
there is no lines if select active playr is on... and duplicate if it is off.... :(
Re: filter tournaments by name or by part of name

Posted:
Tue Aug 12, 2014 2:46 pm
by kraada
Try this filter expression and let me know if it works better:
tourney_table.table_name LIKE '%180%'
Re: filter tournaments by name or by part of name

Posted:
Wed Aug 13, 2014 4:39 am
by jacques
I am affraid to say it don't works
Re: filter tournaments by name or by part of name

Posted:
Wed Aug 13, 2014 7:40 am
by kraada
Do you get any data then?
Re: filter tournaments by name or by part of name

Posted:
Wed Aug 13, 2014 9:39 am
by jacques
still duplicating :/