Hi, We need that users of an organization can see their own userrequest and those created by the other members of the organization, when the userrequests are of the service or department type.
We have modified the UserRequest class with the following scope. <scopes> <scope id="portal-user" _delta="define"> <oql_view> <![CDATA SELECT UserRequest AS T JOIN Organization AS root ON T.org_id = root.id JOIN Organization AS child ON child.parent_id BELOW root.id WHERE T.org_id = :current_contact->org_id AND T.impact IN (1,2) UNION SELECT UserRequest AS T WHERE T.caller_id = :current_contact_id ]></oql_view> </scope></scopes>
The result is the same; users only see their own incidents in the user portal.
Can you please help me? We don't know what we are doing wrong.
Thanks in advance.
Are you referring to actual incidents or user reuests? That would already be one thing.
Furthermore, you didn't redefine the OQL view. ( https://www.itophub.io/wiki/page?id=latest%3Acustomization%3Axml_reference#fields - see "delta" )
I'm referring to a userrequest.
Log in to post a comment.
Hi,
We need that users of an organization can see their own userrequest and those created by the other members of the organization, when the userrequests are of the service or department type.
We have modified the UserRequest class with the following scope.
<scopes>
<scope id="portal-user" _delta="define">
<oql_view>
<![CDATA
SELECT UserRequest AS T
JOIN Organization AS root ON T.org_id = root.id
JOIN Organization AS child ON child.parent_id BELOW root.id
WHERE T.org_id = :current_contact->org_id
AND T.impact IN (1,2)
UNION
SELECT UserRequest AS T WHERE T.caller_id = :current_contact_id
]></oql_view>
</scope></scopes>
The result is the same; users only see their own incidents in the user portal.
Can you please help me? We don't know what we are doing wrong.
Thanks in advance.
Are you referring to actual incidents or user reuests? That would already be one thing.
Furthermore, you didn't redefine the OQL view. ( https://www.itophub.io/wiki/page?id=latest%3Acustomization%3Axml_reference#fields - see "delta" )
Last edit: Jeffrey Bostoen 2023-06-12
I'm referring to a userrequest.