Player report consisting of players seen recently?

[mind_blown]

Is it possible to create a report that contains those players seen recently but with all their hands included in the stats?

If I use the "Last Date / Hands Filter" and set it to "Last 1 Days" I get the right players, but only the hands played in that time.

[Flag_Hippo]

There is a custom report available in this thread for that.

[mind_blown]

Perfect, thank you!

[mind_blown]

The report stopped working today, incidentally when my free trial ran out and I upgraded to the small stakes holdem version. Any chance the two are connected in some way? Like some parts of the formula(s) not being accessible anymore (or causing silent errors) due to the stakes restriction? I've played some hands above small stakes.

[Flag_Hippo]

That's not a known issue as far as I am aware so can you please send us a sample of hands and a support bundle that was created after the report and attach those to a Support Ticket where we can investigate this:

Tutorial: Reporting A Problem

[mind_blown]

Hmm weird, it's working again today. :?

I'll send a support bundle if it happens again.

[mind_blown]

Hmm the report stopped working after midnight. Probably doesn't respect the day starting at 7 am in the settings.

So I edited the filter from:

Code: Select all

player.id_player in (SELECT p.id_player from player p, cash_hand_player_statistics chps where p.id_player = chps.id_player and date_trunc('day', now()) < chps.date_played)

to:

Code: Select all

player.id_player in (SELECT p.id_player from player p, cash_hand_player_statistics chps where p.id_player = chps.id_player and date_trunc('day', now() - INTERVAL '7 HOURS') < chps.date_played)

Boom! Now "today's" stats are still showing even though it's past midnight and will keep working until the morning.

[Flag_Hippo]

Thanks for letting us know what was causing the issue.