adam - 2024-07-01

I have created new extensions for portal inorder for portal user to be able to see ticket assigned to him .
How do i write the OQL query so that the portal user able to see the ticket assigned to him? and also with update capabilities so the portal user able to update public log.

<classes>
<class id="Ticket" _delta="must_exist">
<scopes>
<scope id="all-in-contacts" _delta="define">
<oql_view><![CDATA
SELECT Ticket AS T
JOIN lnkContactToTicket AS l ON l.ticket_id = T.id
WHERE l.contact_id = :current_contact_id
AND T.finalclass IN ('UserRequest', 'Incident')]>
</oql_view>

</scope>
</scopes>
</class>
</classes>

 

Last edit: adam 2024-07-01