Filter anonymous tables from others

[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?

[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.

[Aziz]

Is there a similar expression for cashgames?

[kraada]

Can you give me the name always used for the players at the tables you play?

[Aziz]

Player 1, Player 2 up to Player 9.

[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'))

[Aziz]

OK working, thanks so much