Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by kraada » Wed Nov 07, 2012 9:23 am
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.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by fnopeaw » Wed Nov 07, 2012 9:39 pm
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)
-
fnopeaw
-
- Posts: 124
- Joined: Thu Mar 25, 2010 6:45 pm
by kraada » Thu Nov 08, 2012 10:32 am
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)
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 31 guests