players name in hand report

[WaitWaitW]

hello, i'd like to make a hand report with one one line :
idHand | BB_player_name | SB_player_name | BU_player_name
I don't see how to make this. Is it possible in pt4 ?

Thanks !

[Flag_Hippo]

There is a 'Villain Name (Heads Up) for reports' custom statistic in the Download Warehouse you can use as a basis for that. You can edit the custom column used in that stat to display the name of the player in a specific position instead of villains opponent when two players are dealt in like this:

Code: Select all

select p.player_name
from player p
join cash_hand_player_statistics chps using(id_player)
where chps.id_hand = cash_hand_player_statistics.id_hand
and chps.position = 8

That example is for name of the player in the big blind. You will need separate versions for the SB & BTN.

[WaitWaitW]

Thanks very much!
I made all those stats. I have a new problem now: my report filters are no longer taken into account when I add those stats.

For example, my report shows 799 hands for today. If I add villain (BU), for example, all 33k hands in the database are shown, even though I have the “Today” filter enabled. The same happens with “Players Dealt Into Hand”, etc.

Any idea why this happens?

[Flag_Hippo]

This custom statistic uses a subquery which is doing its own independent JOIN that will not inherit an outer query filter. If you want to filter a report with these types of statistics then you will need to do so with expression filters instead. For example this will filter for todays hands:

Code: Select all

cash_hand_player_statistics.date_played >= CURRENT_DATE

You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'.