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

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
morphisto.zet
Posts: 27
Joined: Tue Jul 12, 2022 8:02 am

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

Post 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?
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

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

Post 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.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
Post Reply