Due Date column not displaying information for overdue tickets

LucasPereira

I set a column to display due date, but it is not displaying this information for overdue tickets

LucasPereira

ntozier

If you click on those tickets (to view them), what is the due date on the ticket?

LucasPereira

Since the ticket is closed instead of due date, close date appears

ntozier

I've asked the devs to take a peak at this thread.

KevinTheJedi

@LucasPereira

So, for your Data de Vencimento queue column you have a Primary Data Source of Due Date and a Secondary Data Source of SLA Due Date. The Due Date value is pulled from the duedate column in the ost_ticket table, and the SLA Due Date value is pulled from the est_duedate column in the ost_ticket table.

Since the column is blank, this means the ticket does not have a duedate value nor a est_duedate value in the database. This is because, if a Ticket is being Closed and the Due Date is in the past the system clears the duedate and est_duedate values. If a Ticket is being Closed and the Due Date is in the future still the system does not clear these values.

I hope this clears up your confusion.

Cheers.

LucasPereira

I remember having the same situation at 1.10v and changing some codes to fix it.
Thank you for your help.
You can close this thread, please.