CA Service Management

  • Private Community

  • 1.  create constraint where root.id is member of a specific group

    Posted Jun 29, 2017 10:35 AM

    I need a create constraint where @root.id is member of a 'XXXX' Group on table ca_contact, somebody can help me with this?

     

    best regards,

    Fabian



  • 2.  Re: create constraint where root.id is member of a specific group

    Broadcom Employee
    Posted Jun 29, 2017 11:36 AM

    Fabian......

     

    What exactly are you attempting to achieve with the constraint?



  • 3.  Re: create constraint where root.id is member of a specific group
    Best Answer

    Broadcom Employee
    Posted Jun 30, 2017 06:17 AM

    Hi Fabian,

     

    Not sure what is the exact requirement but I wonder if you are looking after the group list object and the members attached to a particular group i.e. assignee.[group]group_list.member IN (@root.id) which is aligned with call_req table.

     

    You may find additional examples and information in regards to the store queries in the below documentation.

    https://docops.ca.com/ca-service-management/14-1/en/building/building-ca-service-desk-manager/query-and-message-modifications/scoreboard-queries