Filter colluded players

[4StarGen]

Sry to bother you again, I'm playing with the expression filter and I'm getting multiple entries of the same hand (I know why, since every hand is store from every player perspective), is there are way to avoid this? Maybe a select distinct stament?

[Flag_Hippo]

You can turn on the 'Filter On Active Player' option. Alternatively you can filter for a specific player or position (the BB for example) using built-in filters or within the expression filter. For example this would filter for the hands from Heros perspective only:

Code: Select all

cash_hand_player_statistics.flg_hero and cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.flg_p_first_raise and chps.flg_p_open_opp and chps.id_player = p.id_player and p.player_name = 'Villain')

[4StarGen]

Thanks a lot, I will give it a try.

I've also tried to modify the query and add

Code: Select all

FROM ....,cash_hand_summary

WHERE cash_hand_summary.str_aggressors_p LIKE '898%'

but for some reason, str_aggressors_p is ignored

[Flag_Hippo]

That doesn't need to be a subquery:

Code: Select all

cash_hand_player_statistics.flg_hero and cash_hand_summary.str_aggressors_p LIKE '898%' and cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.flg_p_first_raise and chps.flg_p_open_opp and chps.id_player = p.id_player and p.player_name = 'Villain')