Page 1 of 1

Missing closedat-value for tickets with status 3 (=closed)

Posted: Mon Dec 05, 2022 5:07 pm
by morphisto.zet
Script URL: -
Version of script: 3.4.1
Hosting company: webspaceconfig
URL of phpinfo.php: -
URL of session_test.php: -
What terms did you try when SEARCHING for a solution: searching this forum

Write your message below:
I've written a little script, that automaticlly deletes attachments from tickets that are closed for more than 2 weeks, and another scripts, that anonymizes the ticketdata after 2 years. I'm using the closedat-field for the scripts.

I just noticed, that we have tickets with the status 3 (closed), that have closedat nulled. These are very old tickets (~2012-2014). I believe this comes from an older version of HESK, that didn't use the closedat? Am I right?

Re: Missing closedat-value for tickets with status 3 (=closed)

Posted: Mon Dec 05, 2022 5:18 pm
by Klemen
Correct, "Closed at" was not included in old Hesk versions (it was added in 2.6.0 in 2015). You'd have to parse the "history" row to find the closed dates for those tickets.