Filtering Regs and Recs

[SmartyMcduff]

Hey Ive created a list of regs and I am using this expression filter to look through hands and with other reports but having some issues, its letting non-regs through, any idea what mistake I'm making?

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.id_player = p.id_player and p.player_name in (
'Reg1',
'Reg2'
))

And for Recreationals:

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.id_player and p.player_name NOT in (
'Reg1',
'Reg2'
))

[Flag_Hippo]

That is an expression filter with a subquery used to search hands where 'Player_Name' was dealt in so if you are filtering with the 'Filter Active on Active Player' option turned off you will see stats/hands returned from the perspective of every player dealt in to those hands. If you just want to filter statistics/hands for those specific players then that doesn't need a subquery and you can just use this:

Code: Select all

player.player_name = 'Reg1' OR player.player_name = 'Reg2'

Code: Select all

NOT (player.player_name = 'Reg1' OR player.player_name = 'Reg2')