Start a new topic
Answered

Is there a way to force a manual string primary key to uppercase?

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


Best Answer

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


Answer

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

Thank you. It would be nice to have access to a SemQL expression on the manual key directly.

Login to post a comment