Page 1 of 1

Stats vs Hero

PostPosted: Wed Nov 07, 2012 3:51 am
by fnopeaw
This in PT4 ---> https://www.pokertracker.com/forums/vie ... 15&t=32041

Any chance to have this in HUD ? If not possible to have this info in HUD how do I proceed to make my report in PT4? Thanks !

Re: Stats vs Hero

PostPosted: Wed Nov 07, 2012 4:12 am
by fnopeaw
EDIT: https://www.pokertracker.com/blog/2012/ ... against-me I have already read this. My reason to use those stats are others which I won't discuss here. I just wanna be able to at least make the report I was able to do in PT3 :D

Re: Stats vs Hero

PostPosted: Wed Nov 07, 2012 9:23 am
by kraada
The PT3 style report to show you that data should work similarly in PT4. You can get to the filter expressions in PT4 by clicking the blue Filters link and then Edit Filter Expression - the same style of SQL expression will work there. If you'll give me the exact expression you had in PT3 I'll gladly give you the PT4 equivalent.

Re: Stats vs Hero

PostPosted: Wed Nov 07, 2012 9:39 pm
by fnopeaw
This is the piece of code I'm trying to write in my report but it's giving me error.


holdem_hand_player_statistics.id_hand in (SELECT hhps.id_hand from holdem_hand_player_statistics hhps where hhps.id_player = (SELECT setting_value::int from settings where setting_name = 'my_player_id')
AND hhps.flg_p_first_raise AND hhps.flg_p_open_opp AND hhps.position = 0)

Re: Stats vs Hero

PostPosted: Thu Nov 08, 2012 10:32 am
by kraada
For PT4 you should change it to:

cash_hand_player_statistics.id_hand in (SELECT hhps.id_hand from cash_hand_player_statistics chps where chps.flg_hero
AND chps.flg_p_first_raise AND chps.flg_p_open_opp AND chps.position = 0)