Skip to main content

"The following error occurred: Unknown column reference tickets.date_closed" - Kunskapsbas / 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.

Hjälpfull Oanvändbar

36 av 67 personer tyckte att sidan var användbar

Posta en kommentar

Please log in or register to submit a comment.

Need a password reminder?