Report filter hands vs hero

[CtrlFreak17]

Hi Just wondering if in reports I could filter for where both hero and villain were dealt a hand at the same table?

[Flag_Hippo]

If you mean a specific villain then you can do this in a custom report with an 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')

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

Code: Select all

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.id_player = p.id_player and p.player_name = 'Villain')