Played hands vs a specific player

If you want to see hands where chips were exchanged between you and a specific villain then I recommend using the 'Hero vs Villain' report in the 'Results' section. If you want to see all your hands where a specific player was dealt in then you can do so in a custom report with an expression filter:

Guide: Creating My Reports

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

Replace Villain with a screen name and leave the single quotes - those are needed. You can use this expression filter by clicking on the 'Filters' link in a custom report and selecting 'Add New Expression Filters' and you will need to replace all instances of "cash" with "tourney" if you are in a tournament report.

- Rob

Cheers, this is exactly what I wanted to hear thanks:f_thumbsup: