Expression filter for fish or regs

[J005]

Hi,

I'm looking for an expression filter so to only filter hands vs fish, HU pots, or 3Way HU pots vs fish.
I have created a table with a list of regs, called "reglist_table" in the PT4 database using pgAdmin. Everyone that isn't in this list, is a fish.
Now I want to filter only hands vs fish (or regs) so I can do some database analysis about population tendencies.
What expression filter could I use to select only hands fish or regs in this table?

Otherwise, what expression filter could I use to only filter hands vs a group of players, provided I know their usernames? (eg. "player1", "player2", "player3")

[Flag_Hippo]

Otherwise, what expression filter could I use to only filter hands vs a group of players, provided I know their usernames? (eg. "player1", "player2", "player3")

To see your hands where specific players were dealt in you can use this expression filter:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.id_player = p.id_player and (p.player_name = 'player1' or p.player_name = 'player2'))

You will need to replace all instances of "cash" with "tourney" if you are in a tournament report.