AnsweredAssumed Answered

LEN and ISNUMERIC equivalents for data partition constraints

Question asked by laura.hamersly on Jul 23, 2015
Latest reply on Jul 27, 2015 by Brian_Mathato

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.

Outcomes