Quick Filter

[FilS2BotS]

How to set the filter of the opponent instead of the one of the Active Player... ?

[WhiteRider]

Any filter will apply to the currently active player - if you want to view filtered stats for an opponent you'll need to add/select that player to the player list. If you want to filter for certain opponent actions while viewing yourself you'll need to filter for the action you faced.
If you give us an example of what you want to filter for we'll be able to explain how to do it.

[FilS2BotS]

I would like to filter all the hands to keep only the one where my opponents did a 3 barrel bluff oop :ugeek:

[kraada]

Define "Bluff" for me a little more - what hands count as a bluff in this context?

[FilS2BotS]

high card

[kraada]

Ok, then use the following filter in a custom Hand report to see only hands where your opponent continuation bet the river with a high card hand. One note: this will only work for hands that go to showdown or where he otherwise showed his cards - if he folded after making this bet we do not know whether he was bluffing or not.

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_hand_player_combinations chpc where chps.id_hand = chpc.id_hand and chps.id_player = chpc.id_player and chpc.flg_r_highcard and chps.flg_r_cbet)

Then add the second filter:

flg_r_saw for yourself (ie- that you saw the river)

and you should be good.