How to see hands where a specific player was in my table?

[abusseta]

How I can see hands where a specific player was in my table? no hero vs villian.

Thanks

[kraada]

If you change the active player to that villain you should see all of his data. Unless you are importing datamined hands (which is disallowed at most poker sites) all the data you should see on him should be from when he has played at your table (because that's where PT would get the data from).

[abusseta]

If you change the active player to that villain you should see all of his data. Unless you are importing datamined hands (which is disallowed at most poker sites) all the data you should see on him should be from when he has played at your table (because that's where PT would get the data from).

Yes but i need to know my c won when that player was dealt in my table.

[kraada]

Ah that is more complicated.

The way to do this would be in a custom report on the My Reports page. Create your report as a Player report, and use this Filter Expression (added via the blue Filters link) and that will limit it to times that Player X was dealt into the hand (ie- he was at your table):

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')

Note that the single quotes around the player name are needed.

[abusseta]

Ah that is more complicated.

The way to do this would be in a custom report on the My Reports page. Create your report as a Player report, and use this Filter Expression (added via the blue Filters link) and that will limit it to times that Player X was dealt into the hand (ie- he was at your table):

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')

Note that the single quotes around the player name are needed.

PERFECT!

Thanks you