Is there a way to force a manual string primary key to uppercase?
F
Fathia Jama
a créé un sujet
sur un an il y a
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)?
Meilleure réponse
F
Fathia Jama
a dit
sur un an il y a
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
- Du plus ancien au plus récent
- Populaires
- Du plus récent au plus ancien
Sorted by Du plus ancien au plus récentFathia 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
Voir tous les 178 sujets