Is there a way to force a manual string primary key to uppercase?
F
Fathia Jama
started a topic
over 2 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
F
Fathia Jama
said
over 2 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.
Fathia Jama
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)?
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:
This would force the ID of your Primary Key to be upper cased.
Regards, Peter
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstFathia Jama
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:
This would force the ID of your Primary Key to be upper cased.
Regards, Peter
Fathia Jama
Thank you. It would be nice to have access to a SemQL expression on the manual key directly.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 270 topics