Filter hands by VPIP (or any other villain stat)

[bekonja]

Used custom table from that post: https://www.pokertracker.com/forums/vie ... 83#p330721
Made this filter with "filter on active player":

Code: Select all

cash_hand_player_statistics.id_hand in
(SELECT chps.id_hand from cash_hand_player_statistics chps
WHERE chps.id_player in (select stats.id_player from stats where stats.st_hands > 5 and stats.st_vpip between 40 and 90)
AND chps.flg_vpip)


Applied quick filter "vpip=true".
As a result i have all the hands when hero vpip'ed and a player with at least 5 hands and vpip>40 also vpip'ed. Works on Hands-type report as well. Loading time on 300k+ hands database is around 30 seconds.
Imo that is the solution. If someone can improve it by bypassing custom table creation - that would be really awesome, other than that im extremely satisfied with a result.

[bekonja]

When using said method on Hands type of report its only working when "all hands" option selected in number of displayed result. Choosing "most recent XXX hands" returns some error. I already reported this by a ticket, hope it will get fixed.

[montag]

Great work!! Thanks!!