Page 1 of 1

vs villian(s)

PostPosted: Tue Aug 26, 2014 8:20 pm
by Gabesaurus
How can I see how my opponent sees my stats?

Re: vs villian(s)

PostPosted: Wed Aug 27, 2014 3:28 am
by WhiteRider
You can do this with a custom report filter in My Reports. For example if you add the following as an "expression filter" in a new Player report (with yourself as the active player in the Player List) it will show your stats in cash hands where the specified villain was dealt in:

( 0 < (SELECT count(hhps2.id_hand) FROM cash_hand_player_statistics hhps2 WHERE hhps2.id_hand = cash_hand_player_statistics.id_hand AND hhps2.id_player = (SELECT p.id_player FROM player p WHERE player_name='VILLAIN_NAME_HERE')) )

Remember to change the villain name, but keep the single quotes around the name.
For tournaments change cash_ for tourney_.