How Can I Generate a Custom UUID as Entity Primary Key?
F
Fathia Jama
started a topic
almost 2 years ago
How do I generate a UUID/GUID in a SemQL formula and/or in an Enricher so I can use it as a default in a record attribute (not for a PRIMARY key generated by Semarchy for an entity...I want to populate a field during record authoring).
Best Answer
F
Fathia Jama
said
almost 2 years ago
You can optionally declare the extensions.uuid_generate_v4() function ALREADY required by Semarchy as a custom database function. Not declaring the function gives you a warning, but does not cause an errors in the generation of the UUID. Then I invoke that in an enricher with a 'None" scope and fire that enricher on Form load...essentially creating "default" functionality where there was none.
1 Comment
F
Fathia Jama
said
almost 2 years ago
Answer
You can optionally declare the extensions.uuid_generate_v4() function ALREADY required by Semarchy as a custom database function. Not declaring the function gives you a warning, but does not cause an errors in the generation of the UUID. Then I invoke that in an enricher with a 'None" scope and fire that enricher on Form load...essentially creating "default" functionality where there was none.
Fathia Jama
How do I generate a UUID/GUID in a SemQL formula and/or in an Enricher so I can use it as a default in a record attribute (not for a PRIMARY key generated by Semarchy for an entity...I want to populate a field during record authoring).
You can optionally declare the extensions.uuid_generate_v4() function ALREADY required by Semarchy as a custom database function. Not declaring the function gives you a warning, but does not cause an errors in the generation of the UUID. Then I invoke that in an enricher with a 'None" scope and fire that enricher on Form load...essentially creating "default" functionality where there was none.
Fathia Jama
You can optionally declare the extensions.uuid_generate_v4() function ALREADY required by Semarchy as a custom database function. Not declaring the function gives you a warning, but does not cause an errors in the generation of the UUID. Then I invoke that in an enricher with a 'None" scope and fire that enricher on Form load...essentially creating "default" functionality where there was none.
-
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 216 topics