Hello,
I wish to write SQL queries to get the data from specific job tickets in our database but I cannot find any data stored relating to the Due Date.
I can find the data for REPORT_DATE and LAST_UPDATED which is fine but nowhere can I find anything relating to the due date.
For each job ticket in our helpdesk I can view the details of the due date under 'Status & Schedule', but I am wondering if this data is stored permanently somewhere or if it perhaps might be calculated based on the open date and what we have specified as a schedule.
Any help would be greatly appreciated.
Many thanks.