Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

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

                     ot.created created,
                     ot.duedate duedate,
                         WHEN ot.closed IS NULL THEN "OPEN"
                         ELSE "CLOSED"
                     END AS case_status,
                     otc.title AS task,
            AS department,
                     CONCAT_WS( " ", os.firstname, os.lastname ) AS agent
                FROM ost_task ot
                     LEFT JOIN ost_task__cdata otc on
                     LEFT JOIN ost_department od ON
                     LEFT JOIN ost_staff os ON ot.staff_id=os.staff_id

How do I join ost_thread_entry to get the updates.


Sign In or Register to comment.