Is there a way to limit user view of tickets for only the tickets in which he is set as assginee or if he is set as an assignee of one of the tickets workflow tasks?
It is needed for audit
A data-partition constraint applied to the relevant table similar to the one below should do the trick for tickets assigned to the logged-in user:
assignee = @root.id
Hope this helps?
If you limit the viewing of tickets to only those which are assigned to the logged-in analyst then they would not be able to see tickets where they are the customer or requester, etc. They would also be limited to helping other analysts on a ticket unless the analyst transferred the ticket to them.
I would recommend against such a restrictive approach.
Retrieving data ...