Luc Boissonneault
Enteprise / Solutions Architect
Asked a question 8 months ago
Is there a way to force a manual string primary key to upper case upon save (since enrichers are not permitted on keys) through configurations only (not DB wizardry)?
Is there a way to force a manual string primary key to upper case upon save (since enrichers are not permitted on keys) through configurations only (not DB wizardry)?
Peter TseSEMARCHY TEAM
Training & Solutions Architect at Semarchy
Hi Luc
Yes, you can set your Primary Key Attribute to ID Generation of SemQL and of type String.
Create a simple attribute, for example, named IDCode. Then your SemQL expression for the ID generation would be this:
UPPER(IDCode)This would force the ID of your Primary Key to be upper cased.
Regards, Peter