Filtering Specific villains in specific position

[KinitoBW]

Hello,

Im trying to create a report where I can filter my game vs specific villains in BB (regs) (playing Spins)

I need to know the expresion filter, if it exist something like for example Villain in BB nickname = Nickname.

If I play from de SB I used the stat "winner" but sometimes when Im the winner of the pot I cannot filter good because the looser could be a fish.

I hope you can understand what im looking for

Best regards!

[Flag_Hippo]

Code: Select all

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.position = 8 and thps.id_player = p.id_player and p.player_name = 'Villain')

When using this expression filter replace Villain with the screen name and leave the single quotes - those are needed.

[KinitoBW]

Thanks a lot! It works perfect!