opp. 3bet jam range report?

[olistr]

I have pop up EXPRESSION IS NOT VALID
I copy paste this
holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics WHERE id_player != (select setting_value::int from settings where setting_name = 'my_player_id'))

[WhiteRider]

Sorry, I forgot you were in the tournament section. It seems that I don't have quite the right format, though. I'm sure Kraada will be able to correct it when he comes on.

[kraada]

For tournaments it would be:


tourney_holdem_hand_player_statistics.id_hand in (SELECT tourney_holdem_hand_player_statistics.id_hand from tourney_holdem_hand_player_statistics WHERE id_player != (select setting_value::int from settings where setting_name = 'my_player_id'))

[olistr]

[kraada]

My apologies this will validate:

tourney_holdem_hand_player_statistics.id_hand in (SELECT tourney_holdem_hand_player_statistics.id_hand from tourney_holdem_hand_player_statistics WHERE tourney_holdem_hand_player_statistics.id_player != (select setting_value::int from settings where setting_name = 'my_player_id'))

[olistr]

expression work, but report again write out only my hole cards only
not opponent hole cards
I loosing hope a bit that it is possible, if it is too complicated or impossible I def. can live without it
I will not get angry if you let it be

[kraada]

Do you play at multiple sites?

[olistr]

No only poker stars

[kraada]

Do you have your screen name set via the Settings button in the main PT3 window? That is what the setting we're using in the filters corresponds to.

[olistr]

If you mean settings under tournament tab next to player and site window, then yes I have set my sreen name there