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)?

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