Page 1 of 1

Filter my stats against one specific villain

PostPosted: Sun Jan 06, 2013 12:39 pm
by Link23
Hey,

I play Heads Up cashgame. I want to show my stats vs one specific villain over a period of time/hands. How can I do that?

Best regards,
Link.

Re: Filter my stats against one specific villain

PostPosted: Sun Jan 06, 2013 6:07 pm
by WhiteRider
Check out this post which explains how to do that.

Re: Filter my stats against one specific villain

PostPosted: Mon Jan 07, 2013 6:12 am
by Link23
Thank you for your reply but I play Cashgames and not tourneys. If I change "Villain" to my preferred villain I want to filter, I can´t see any hands displayed.

Re: Filter my stats against one specific villain

PostPosted: Mon Jan 07, 2013 11:23 am
by kraada
Change the two instances of "tourney" to "cash" and it will work for cash games then.

Re: Filter my stats against one specific villain

PostPosted: Tue Jan 08, 2013 5:36 am
by Link23
I´ve done that. I still don´t get a report.

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

I changed the bolt part into villains ID.

Re: Filter my stats against one specific villain

PostPosted: Tue Jan 08, 2013 9:43 am
by kraada
Try this instead:

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