Clarity

  • 1.  Set as Unique for custom attribute

    Posted Jan 10, 2019 07:33 AM

    CA PPM SAAS 15.5

     

    Is there anyway to create a custom attribute with unique?

     

     

    Thanks in advance for your help

     

    Thanks

    -Venkitta



  • 2.  Re: Set as Unique for custom attribute

    Posted Jan 10, 2019 07:39 AM

    If it is a selection form another list, perhaps this would help;

    How to make a attribute of an object to have only unique values in CA PPM 

     

    Or use a auto-generated sequence if its an "id" type column.

     

    If its just a data-entry column, not sure I can think of a way (apart from reporting on it afterwards and "correcting" the data somehow)..



  • 3.  Re: Set as Unique for custom attribute

    Posted Jan 10, 2019 07:55 AM

    Thanks David.  I forgot to mention that, the attribute is just a text field and auto-numbering is not allowed.  

     

    I'm trying to provide alternate solution as currently, the user is using OOTB Task ID attribute for capturing this unique values and we would like to propose a custom attribute with unique values.



  • 4.  Re: Set as Unique for custom attribute

    Posted Jan 10, 2019 08:40 PM

    If you are on-premise, you could use a database trigger to verify if the value has been used.  SaaS, don't believe it can be done for a 'unique string' attribute.

    You could write a portlet to identify when non-unique it has occurred, and manually update one of the records.

    You could also consider using the PRID on PRTASK (aka the 5,000,000) which is already unique.

    It just depends on what you are attempting to resolve in having a 'unique string field'.