Hi everyone!
Please help me to write oql query, which selects escalated tickets. I managed to write only for one child class.
SELECT Ticket AS T JOIN Contact AS C ON T.agent_id = C.id JOIN UserRequest AS R ON R.agent_id = C.id WHERE R.escalation_flag = "yes" AND T.id = R.id AND C.id = :current_contact_id
But I need for all classes. The query is needed to show current contact's escalated tickets in User Portal
Thank you!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi everyone!
Please help me to write oql query, which selects escalated tickets. I managed to write only for one child class.
SELECT Ticket AS T JOIN Contact AS C ON T.agent_id = C.id JOIN UserRequest AS R ON R.agent_id = C.id WHERE R.escalation_flag = "yes" AND T.id = R.id AND C.id = :current_contact_idBut I need for all classes. The query is needed to show current contact's escalated tickets in User Portal
Thank you!
Hello,
escalation_flagis a UserRequest class field.What do you mean by children classes ?