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.

도움이 되었습니다 Unhelpful

42 of 75 people found this page helpful

댓글 등록

Please log in or register to submit a comment.

Need a password reminder?