Hand filter - all hands played vs a specific tendecy

[4StarGen]

I'd like to make a filter that:
- include all players, not only Hero
- filter whenever players plays a hand vs a group of players that has VPIP > 40

How can I do that?

[Flag_Hippo]

This expression filter will give you hands where there was at least one player with a VPIP greater than 40%:

Code: Select all

cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps, cash_cache cc where chps.id_player = cc.id_player group by chps.id_hand, chps.id_player having ((sum(cc.cnt_vpip) * 1.0) / (sum(cc.cnt_hands) * 1.0) - sum(cc.cnt_walks) * 1.0) > .4)

Filters that use subqueries like this can generate a lot of PostgreSQL processing so can take a while to complete if you have a large database.