CA Service Management

  • 1.  Data Partition to compare 2 fields

    Posted Jun 08, 2016 11:28 AM

    Does anybody knows how can I compare 2 fields in Data Partition (create; table Call_Req)?

     

    Restriction:

    customer.tenant.id = category.tenant.id

     

    If I try this, I receive the following error:

    AHD05800:Where clause incorrect. Invalid restriction. Could not recognize category.tenant.id.

     

    There is another way to solve that?

     

     

     



  • 2.  Re: Data Partition to compare 2 fields

    Broadcom Employee
    Posted Jun 08, 2016 02:20 PM

    I'm not sure that this data partition would work, but I'm also concerned with the use of dotted references, which will often not work well with non-view data partition constraints. I think a better option would be custom spel code, but I don't have any examples to provide.

    Does anybody else have any ideas?



  • 3.  Re: Data Partition to compare 2 fields

    Posted Jun 10, 2016 10:15 AM

    Hi Fabiano, if the ticket is being created under the same tenant as the end user, then you can create a data partition as follows:

     

    category.tenant.id = tenant.id

     

    Sandra

     



  • 4.  Re: Data Partition to compare 2 fields

     
    Posted Jun 14, 2016 05:34 PM

    Hi fabiano.ldomingues - Did any of the responses help answer your question? If so please mark as Correct Answer. Thanks!



  • 5.  Re: Data Partition to compare 2 fields

    Posted Jun 14, 2016 05:39 PM

    Hi Chris, we are addressing this via a ticket. The solution suggested didn't work so far.



  • 6.  Re: Data Partition to compare 2 fields

     
    Posted Jun 14, 2016 05:41 PM

    Thanks for the update Sandra!



  • 7.  Re: Data Partition to compare 2 fields
    Best Answer

    Posted Jun 15, 2016 12:56 PM

    Well, we had the confirmation such comparison is not possible because the affected end user information is not in the table yet, thus it will not work.

    The only way to achieve this is via customization.

     

    A new Idea was created for this:

    Restrict Category selection for Analysts with Multi-Tenancy ON

    https://communities.ca.com/ideas/235731671

     

    I appreciate if it could be voted up.

     

    Regards

    Sandra