AnsweredAssumed Answered

Scoreboard query based on number of hours

Question asked by Victor_C on Dec 13, 2016
Latest reply on Dec 14, 2016 by Victor_C

I am trying to create a scoreboard query to show tickets that have an SLA that will expire in the next 48 hours.

There is an existing query,

active = 1 AND attached_slas.time_to_violation < EndAtTime(\'TODO_TODAY\')

for tickets that will expire today that I would like to customize for my 48 hour timeframe.

I am having trouble figuring out the format to define the time. I have tried things like

EndAtTime(\'NEXT_48_HOURS\') and EndAtTime(\'NEXT_48hours\'), based on other queries I've seen but have not had success.

Thanks for any assistance!

Victor

Outcomes