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.

Βοηθητικό Δεν βοηθάει

11 από 21 χρήστες πιστεύουν ότι αυτή η σελίδα βοηθάει

Προσθήκη σχολίου

Please log in or register to submit a comment.

Ξεχάσατε τον κωδικό πρόσβασης;