osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Relationship between ost_task and thread
Can you please tell me the relationship between ost_task and ost_thread_entry.
I have a task which has had 2 updates
WHEN ot.closed IS NULL THEN "OPEN"
END AS case_status,
otc.title AS task,
od.name AS department,
CONCAT_WS( " ", os.firstname, os.lastname ) AS agent
FROM ost_task ot
LEFT JOIN ost_task__cdata otc on ot.id=otc.task_id
LEFT JOIN ost_department od ON ot.dept_id=od.id
LEFT JOIN ost_staff os ON ot.staff_id=os.staff_id
How do I join ost_thread_entry to get the updates.