Hands that go to showdown that include a specific villain

[mishroom222]

Hi.

I am trying to build a hand report, where it includes all hands that:
- go to showdown
- include myself & a specific villain

I've done some googling and I've found this bit of code to use as an expression filter (where villain is replaced with the persons username) :

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 = 'villain')

But this includes all hands where villain was part of the ring, not necessarily betting in hands and going to showdown. Is there a way to narrow this down to only include hands where villain sticks until showdown?

Thanks

[Flag_Hippo]

Code: Select all

cash_hand_player_statistics.flg_showdown and 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 = 'villain' and chps.flg_showdown)

[mishroom222]

Thanks! This worked :)