Report: filter out hero?

[js2002]

...statistics:

#Player# != 'heroname'

doenst work.

[WhiteRider]

I came across that a while ago and from my note it looks as if adding another filter too (e.g. filtering to a limit, or probably all limits) might let you get around this until the bug is fixed.

[js2002]

no, the only one that workarounds :) is filtering out my handcount.

[kraada]

This would do it:

id_hand NOT IN (SELECT id_hand from holdem_hand_player_statistics where holdem_hand_player_statistics.id_player = (SELECT setting_value::int from settings where setting_name = 'my_player_id'))

[js2002]

tu

[js2002]

http://img200.imageshack.us/img200/8541 ... 012362.jpg

Doenst work.

[kraada]

No, I meant to copy and paste what I have exactly. my_player_id is the setting name that is used in our database. No alteration is necessary to the above filter.

[js2002]

same fault

[kraada]

Make sure you have the single quotes as well:
id_hand NOT IN (SELECT id_hand from holdem_hand_player_statistics where holdem_hand_player_statistics.id_player = (SELECT setting_value::int from settings where setting_name = 'my_player_id'))

is EXACTLY how it should look. I tested this and it works fine for me.

[js2002]

http://img684.imageshack.us/img684/6774 ... 018351.jpg

Trust me!

EDIT: made another test: column id_hand is ambiguous!