Expression no longer valid?

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Expression no longer valid?

Postby Zangeeph » Thu May 03, 2012 11:29 am

tourney_hand_player_statistics.id_hand in (SELECT thhps.id_hand from tourney_hand_player_statistics thhps, tourney_hand_player_detail thhpd where thhps.id_hand = thhpd.id_hand and thhps.id_player = thhpd.id_player and thhps.position = 9 and thhpd.amt_before BETWEEN 510 and 520)

This expression has stopped validating. It has worked in the past, I am unsure why it is no longer a valid expression. I know it has worked in the past because I have old reports saved that have that filter saved (a filter expression will not save if it not valid) but when I run then it just gives a huge error. How can I make this valid again?
Zangeeph
 
Posts: 205
Joined: Thu Jun 23, 2011 6:27 pm

Re: Expression no longer valid?

Postby kraada » Thu May 03, 2012 12:38 pm

The player_detail table was removed in our effort to improve performance. All player_detail values were merged into player_statistics.

The filter now also looks a lot cleaner as a bonus (and should run a lot more quickly too):

tourney_hand_player_statistics.id_hand in (SELECT thhps.id_hand from tourney_hand_player_statistics thhps where thhps.position = 9 and thhps.amt_before BETWEEN 510 and 520)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 1 guest