AAvsKK, net expected won filters

[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

[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.

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

[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.

[seadog]

Expression not valid

[kraada]

That filter works for me - exactly where are you trying to put it?

[seadog]

blue filters then "add new expression filters"

[WhiteRider]

Kraada's filter works for me too - if you're in the Tournament section you need to replace "cash_" with "tourney_".

[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