1 Reply Latest reply on May 16, 2018 7:12 AM by fluffy midnight

    Would anybody know where I would find the data for 'DUE DATE' in my SQL database?

    mnightingale

      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.