CA Service Management

Expand all | Collapse all

Data Partition Help

Jump to Best Answer
  • 1.  Data Partition Help

    Posted 08-24-2016 09:12 AM

    Hello team,

     

    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

     

    thanks



  • 2.  Re: Data Partition Help

    Posted 08-24-2016 01:02 PM

    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?



  • 3.  Re: Data Partition Help

    Posted 08-24-2016 04:14 PM

    exactly



  • 4.  Re: Data Partition Help

    Former Employee
    Posted 08-31-2016 07:05 PM

    Hi ianprogrammer - Did Lindsay_Estabrooks's response help answer your question? If so please mark as Correct Answer. Thanks!



  • 5.  Re: Data Partition Help
    Best Answer

    Posted 08-27-2016 12:03 PM

    then I think your Constraint should be:

    owning_contract.svc_owner IN @root.id