SLA time format doubt

English! place to talk about development, programming and coding
Post Reply
cris12345
Znuny advanced
Posts: 105
Joined: 24 Feb 2017, 16:45
Znuny Version: 5.0.16.01
Real Name: Cristina Corrales
Company: -

SLA time format doubt

Post by cris12345 »

Hello,

Quick question, the SLA is saving the minutes amount according to each calendar, but in somehow it saved the final hour in a regular time format?

I mean, If a ticket is created at 3pm and only have 2hours of SLA
I have to write 120 in solution time section on the SLA.
But in the database table "sla" is saving the 120 not the datetime and I need that final datetime. Any idea how can I get it?

I was thinking to take the amount and divided in 60 and then by 24. But If I apply an adddate() it wouldn't avoid weekend days.

Thanks
RNS
Znuny newbie
Posts: 1
Joined: 31 May 2017, 09:43
Znuny Version: 5.0.11
Real Name: shivaraj

Re: SLA time format doubt

Post by RNS »

hi,

by default it saved in minutes format in sla table and it will be taken as reference time to calculate sla for ticket.

to get ticket escalation date time go to table ticket and you will find column escalation_solution_time(unix timestamp) which is the final datetime of sla.
Post Reply