Page 1 of 1

Filter anonymous tables from others

PostPosted: Sun Jun 26, 2016 8:44 am
by Aziz
Hi!

On the site I play there are both anonymous and normal tables on the same limit. Can you somehow filter results from only normal tables or anonymous tables?

Re: Filter anonymous tables from others

PostPosted: Sun Jun 26, 2016 1:24 pm
by Flag_Hippo
That may be possible in a custom report using expression filters in a similar way to this thread based on the player names at the anonymous tables assuming they are always something like Player1, Player2 e.t.c.

Re: Filter anonymous tables from others

PostPosted: Sun Jun 26, 2016 2:19 pm
by Aziz
Is there a similar expression for cashgames?

Re: Filter anonymous tables from others

PostPosted: Mon Jun 27, 2016 7:48 am
by kraada
Can you give me the name always used for the players at the tables you play?

Re: Filter anonymous tables from others

PostPosted: Mon Jun 27, 2016 10:02 am
by Aziz
Player 1, Player 2 up to Player 9.

Re: Filter anonymous tables from others

PostPosted: Mon Jun 27, 2016 10:20 am
by kraada
cash_hand_player_statistics.id_hand not in (select chps.id_hand from cash_hand_player_statistics chps, player p where chps.id_player = p.id_player and (p.player_name = 'Player 1' or p.player_name = 'Player 2' or p.player_name = 'Player 3' or p.player_name = 'Player 4 ' or p.player_name = 'Player 5' or p.player_name = 'Player 6' or p.player_name = 'Player 7' or p.player_name = 'Player 8' or p.player_name = 'Player 9'))

Re: Filter anonymous tables from others

PostPosted: Mon Jun 27, 2016 2:02 pm
by Aziz
OK working, thanks so much :D

highfalutin