Sort out hands from last 5 hours

[Lakestone]

Is it possible to add a filter to 'Report Stats' to get all hands to display from the last 5 hours of play inside 'Holdem Tournament Hand' in 'Reports' ?

[kraada]

Yes use this filter:

tourney_holdem_hand_player_statistics.date_played > now() - interval '5 hours'

[Lakestone]

Yes use this filter:

tourney_holdem_hand_player_statistics.date_played > now() - interval '5 hours'

This did not do it for me, I got zero hands, even though I have no other filter and have played about 1000 hands the last hour :?:

[kraada]

Do you use the My Day Starts At setting value?

[Lakestone]

Do you use the My Day Starts At setting value?

12 Midnight

[kraada]

That's odd that should have worked, but try this and see if this works better for you:

tourney_holdem_hand_player_statistics.id_hand in (SELECT thhps.id_hand from tourney_holdem_hand_player_statistics thhps where thhps.date_played > now() - interval '5 hours')

[Lakestone]

tourney_holdem_hand_player_statistics.id_hand in (SELECT thhps.id_hand from tourney_holdem_hand_player_statistics thhps where thhps.date_played > now() - interval '5 hours')

Better, but 10h works more like h5 and 5h more like 1h ? :(

[WhiteRider]

It could be affected by your timezone - times are stored in the database as GMT/UTC times, so if you're comparing the unadjusted times you may need to include an offset. Once you figure out what that offset is it should remain consistent, so you might always need to add 4 hours, or whatever, to the value you actually want.

[Lakestone]

It could be affected by your timezone - times are stored in the database as GMT/UTC times, so if you're comparing the unadjusted times you may need to include an offset. Once you figure out what that offset is it should remain consistent, so you might always need to add 4 hours, or whatever, to the value you actually want.

Oh I see, I guess its working as intended then - thanks man ;)