filter for hero vs specific opponent

[dave2085]

Is this possible? I'd like some kind of global filter to show only my stats vs particular players (for headsup sng.)

hx fpr help i found one for pt4, but this doesnt work for pt3

[kraada]

This can be done in PT3's custom reports using the following filter expression:

tourney_holdem_hand_player_statistics.id_hand in (SELECT chps.id_hand from tourney_holdem_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'Player X')

[busta_ci]

Hello,

How to adjust this filter for cashgame ?

I've tried cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'Player X')

but it doen't work.

Thank you

[kraada]

That should do it. What are you seeing happen? It should get you all hands Player X was dealt into (note that Player X is case sensitive).

[busta_ci]

That should do it. What are you seeing happen? It should get you all hands Player X was dealt into (note that Player X is case sensitive).

I have "Expression is NOT valid!"

[kraada]

Then you mistyped - I just copied in exactly what you pasted and it validates for me. Make sure you don't have an extra carriage return before you start the expression - that can cause it to be parsed as invalid.

[busta_ci]

Then you mistyped - I just copied in exactly what you pasted and it validates for me. Make sure you don't have an extra carriage return before you start the expression - that can cause it to be parsed as invalid.

I've tried to write it without copy/paste and it still doesn't work.

To insert this filter I have to click on filter (blue word) and put the expression in the blank space right ? It should be working with any selected section/report ?

[kraada]

My apologies, I missed that you were doing this in PT3.

In PT3 it's:

holdem_hand_player_statistics.id_hand in (SELECT chps.id_hand from holdem_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'Player X')

[busta_ci]

It works

Thanks for your help.