I'd recommend using the 'Hero vs Villain' report in the 'Results' section as that uses data from hands where chips were exchanged between you and a specific villain. If you want to see all your hands where a specific player was dealt in a custom report then you can use this expression filter:
- Code: Select all
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'.