Skip to main content

"The following error occurred: Unknown column reference tickets.date_closed" - Developer & Reporting / Creating Reports - Deskpro Support

"The following error occurred: Unknown column reference tickets.date_closed"

Authors list

Question:

I'm getting this error when I try to run a custom report:

The following error occurred: Unknown column reference tickets.date_closed

What's causing this?

Answer:

Earlier versions of Deskpro referred to tickets.date_closed to mean the date that a ticket was archived. This was left over from previous terminology. In builds post-October 2014, you should use tickets.date_archived.

In addition, tickets.status will have value 'archived' instead of 'closed' for archived tickets.

Note that our upgrader will attempt to rewrite your custom queries to use the new values.

Helpful Unhelpful

6 of 13 people found this page helpful

Add a comment

Please log in or register to submit a comment.

Need a password reminder?