I need to make some like this :
Table name : prob_category
where clause : owning_contract in "@root.svc_contract.id"
its possible to select all categories of contracts containing the current user ?
sorry about my bad english
Let me state what I think I understand about your data partition.
You want to restrict the view of the Incident/Problem/Request Area only to those Areas which have a Service Contract where the logged-in user is the Client Contact for that Service Contract.
Is that correct?
Hi ianprogrammer - Did Lindsay_Estabrooks's response help answer your question? If so please mark as Correct Answer. Thanks!
then I think your Constraint should be:
owning_contract.svc_owner IN @root.id