Filter hands based off player names

[Kevweiser]

I would love to filter hands so that I can see how I am doing vs a specific player or players. Also, I could filter datamined hands to see how players are playing against each other.
For example:
Hand contains "My Name" AND "Villain"
Hand contains "Durrrr" AND "Jungleman12"

Obviously I could look at the "Hero vs Villain" report, but that is a limited report.

[kraada]

You can create a report in My Reports that does this using the following Filter Expression:

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

That will filter to all hands Villain was dealt into (note that Villain is case sensitive and the single quotes are needed).

[Kevweiser]

Thanks!