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

Start a new topic

Answered

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

Fathia Jama

started a topic almost 3 years 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)?

Best Answer

Fathia Jama said almost 3 years ago

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

2 Comments

Fathia Jama

said almost 3 years ago

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

Fathia Jama

said almost 3 years ago

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