Filter Player Report by note colour?

[00gamblor00]

Hi,

Is there a way to add a filter to an all players report so that only players with a certain note colour are included?

Thanks

[kraada]

Unfortunately there isn't an easy way to do this at this time.

[pasita]

Seems to work at least in the default all player report, add to Expression Filters:

2 in (select id_color from notes where id_x=cash_hand_player_statistics.id_player)

where 2 means green, 8 is orange, for example. YMMV, run some checks if you plan to trust this for money's worth. Let me know if you find a problem.

[expiat]

Hi, the expression that pasita wrote works perfecty, but if we want to exclude some colours like NOT 5 in then its not working..expression is valid but doesnt do anything!
Basicaaly i ask to exclude so to see the players that are uncoloured!!

Any way to solve it?

Thanks in advance!

[WhiteRider]

This works for me:

2 not in (select id_color from notes where id_x=cash_hand_player_statistics.id_player)

[noxee]

This works for me:

2 not in (select id_color from notes where id_x=cash_hand_player_statistics.id_player)

Hi, how can I exclude 3 color code ?

Include seems work (10k hands to approx. 5k hands> seems fine) :

Code: Select all

1 in (select id_color from notes where id_x=tourney_hand_player_statistics.id_player)
OR 2 in (select id_color from notes where id_x=tourney_hand_player_statistics.id_player)
OR 6 in (select id_color from notes where id_x=tourney_hand_player_statistics.id_player)

But not exclude (10k hands to approx 15k hands > ) :

Code: Select all

1 not in (select id_color from notes where id_x=tourney_hand_player_statistics.id_player)
AND 2 not in (select id_color from notes where id_x=tourney_hand_player_statistics.id_player)
AND 6 not in (select id_color from notes where id_x=tourney_hand_player_statistics.id_player)

"Filter on Active Player" is untick for both filters
I use also basic filters : this month / 50€ BI / 2player only


Thanks

[Flag_Hippo]

'AND' will not work because a player cannot be yellow AND green AND Red e.t.c. If you change 'AND' to 'OR' that's problematic too because if you do NOT Yellow or NOT Green you will still get yellow and green players because yellow players are not green and vice versa. The easiest thing to do is filter for the colors you do want in your expression but if you want to create a filter expression for this you can do that with a custom column:

player_color=

Code: Select all

CASE WHEN (SELECT id_color FROM notes WHERE id_x = player.id_player) IS NULL THEN -1 ELSE (SELECT id_color FROM notes WHERE id_x = player.id_player) END

and then you can use a filter expression like this:

Code: Select all

player_color not in (-1,1,2,3)

where -1 means no color.

[noxee]

Hi,

Can I do that with PT4 : my winrate vs some type of players (using note color) when I have specifically hands ?

eg. my winrate vs recs when I push K8-K2 (HU 7-13deep)

Thanks.

[Flag_Hippo]

That would be more complex to filter for and is beyond my own knowledge.

[noxee]

That would be more complex to filter for and is beyond my own knowledge.

But it's really doable via PT4 ? Or only via PostgreSQL ?

Thx.