Page 1 of 1

AAvsKK, net expected won filters

PostPosted: Tue Jul 17, 2012 12:16 pm
by seadog
Net expected won registers 0.00 only

AAvsKK no longer works, 10 lines of red text appear. The filters section says expression not valid.
Haven't found resolution that works.

Help!!
I

Re: AAvsKK, net expected won filters

PostPosted: Tue Jul 17, 2012 1:58 pm
by kraada
Could you paste the filter expression you're using here? I'll be able to tell you how to fix it once I can see it.

Re: AAvsKK, net expected won filters

PostPosted: Tue Jul 17, 2012 3:02 pm
by seadog
holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics WHERE holdem_hand_player_statistics.id_holecard = 1)

holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics WHERE holdem_hand_player_statistics.id_holecard = 26)

As for net expected won, it won't load anything anymore; "Unable to load query into control. reason: Access violation (0) (Flags:0:
Address 0x004df927; EIP: 0x004DF927)

Re: AAvsKK, net expected won filters

PostPosted: Tue Jul 17, 2012 3:48 pm
by kraada
In PT4 it's:

cash_hand_player_statistics.id_hand in (SELECT cash_hand_player_statistics.id_hand from cash_hand_player_statistics WHERE cash_hand_player_statistics.id_holecard = 1)

and the same for KK (just = 26).

Try making those changes, saving the report and restarting PT4 and then let me know what happens.

Re: AAvsKK, net expected won filters

PostPosted: Tue Jul 17, 2012 4:42 pm
by seadog
Expression not valid

Re: AAvsKK, net expected won filters

PostPosted: Tue Jul 17, 2012 5:11 pm
by kraada
That filter works for me - exactly where are you trying to put it?

Re: AAvsKK, net expected won filters

PostPosted: Tue Jul 17, 2012 10:04 pm
by seadog
blue filters then "add new expression filters"

Re: AAvsKK, net expected won filters

PostPosted: Wed Jul 18, 2012 3:59 am
by WhiteRider
Kraada's filter works for me too - if you're in the Tournament section you need to replace "cash_" with "tourney_".

Re: AAvsKK, net expected won filters

PostPosted: Wed Jul 18, 2012 11:24 am
by seadog
ok got it

Was trying to edit existing filter
Created two new ones and all is well there


Now to get net ecpected won woroking