Show all Tickets of an Organiszation wit SQL

fbmr

Hallo,
gibt es eine möglichkeit alle offenen Tickets einer Organisatzion mit einem SQL Statement abzufragen?

ntozier

Google Translate
"is there a way to query all open tickets of an organization with an SQL statement?"

Tickets do not have an Organization, so not easily.

You would have to find all users that were in an organization. Then you would have to do a query to see what tickets had those users in an open state.

heart1010

Have you found the correct SQL statement for that @fbmr ?

fbmr

no sorry i´ve dont found a way

PavelH

SELECT * FROM `ost_ticket` WHERE `status_id` = 1 AND (`staff_id` IN (SELECT `staff_id` FROM `ost_staff` WHERE `dept_id` = 1))