Filter colluded players

[4StarGen]

I'd like to review some collusion spots within some players, I've managed to create a hand report and filter hands based on player name using the expression filter

Code: Select all

#Player" IN (x,y)

And toggling the "filter on active player" filter

This is filtering all the hands the two players are in, but I'd like to be more specific, namely filter out where one of those player 3bet, how can i do it?

[Flag_Hippo]

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where NOT chps.flg_p_3bet and chps.id_player = p.id_player and p.player_name = 'Villain')

[4StarGen]

Thanks a lot but I don't understand the query, why you put the

NOT chps.flg_p_3bet

?

[Ventilatorrr]

I think there was a misunderstanding - if you want to see hands where one of the players did 3bet, then NOT shouldn't be used.

[4StarGen]

Ok cool, sry for the dumb question but it will be the last.
Let's say I have 10 players to analyze and I want to filter out the hands in which one of those 10 players have RFI, how can I do it?

Ty very much

[Flag_Hippo]

Change:

Code: Select all

chps.flg_p_3bet

to:

Code: Select all

chps.flg_p_first_raise and chps.flg_p_open_opp

[4StarGen]

Thanks for the assistance first of all

I haven't tried the query but from my understanding the query filter out hands that player A have played against player B in a specific spot, unfortunately that's not what I have to do.

I have a group of 10 players that are constantly colluding, so I need a hand report where one of those 10 players (let's call them p1,p2,p3...) have raised RFI for example in general

[Flag_Hippo]

I haven't tried the query but from my understanding the query filter out hands that player A have played against player B in a specific spot, unfortunately that's not what I have to do.

The expression filter is hand specific and not player specific. For example if your hand report is for 'Player A' and if 'Player B' is inserted into the expression filter then you will see the hands that 'Player B' raised first in from the perspective of 'Player A'.

I have a group of 10 players that are constantly colluding, so I need a hand report where one of those 10 players (let's call them p1,p2,p3...) have raised RFI for example in general

If you make the changes that I suggested then this expression will filter for hands where the named player raised first in:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.flg_p_first_raise and chps.flg_p_open_opp and chps.id_player = p.id_player and p.player_name = 'Villain')

[4StarGen]

I haven't tried the query but from my understanding the query filter out hands that player A have played against player B in a specific spot, unfortunately that's not what I have to do.

The expression filter is hand specific and not player specific. For example if your hand report is for 'Player A' and if 'Player B' is inserted into the expression filter then you will see the hands that 'Player B' raised first in from the perspective of 'Player A'.

I have a group of 10 players that are constantly colluding, so I need a hand report where one of those 10 players (let's call them p1,p2,p3...) have raised RFI for example in general

If you make the changes that I suggested then this expression will filter for hands where the named player raised first in:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.flg_p_first_raise and chps.flg_p_open_opp and chps.id_player = p.id_player and p.player_name = 'Villain')

Thanks for everything <3, one last question if you don't mind. Can I use built-in filters to search out spots in some way? Like I would do if for a single player?
So I'd like to use the query above (without the hand conditions, but only the player list) and use PT4's GUI to filter out spots

[Flag_Hippo]

You can use built-in filters alongside expression filters.