CA Service Management

Expand all | Collapse all

LEN and ISNUMERIC equivalents for data partition constraints

  • 1.  LEN and ISNUMERIC equivalents for data partition constraints

    Posted 07-23-2015 03:35 PM

    Are there LEN and/or ISNUMERIC equivalents for setting constraints in the data partition for fields? There is a field that I'm in the process of adding. Even though the input should be all numeric initially, it should be treated like a string. Only one of my groups will use this field, but only if a specific request area is used.

     

    I realize that I could create the field as an integer, but there is a point where I would have a trigger to change it to a string value, after the analyst is finished working with the ticket.

     

    As for the LEN constraint, we want to set a minimum number of required characters if the field needs to be used.



  • 2.  Re: LEN and ISNUMERIC equivalents for data partition constraints

    Posted 07-27-2015 09:25 AM

    Unfortunately, data-partitions are not designed to do such complex computations.

     

    I would imagine doing this with JavaScript, spel-code, webservice or ITPAM