- Do you have any recommendations (alert point) when using an identifier from a source system. In connection with this following documentation.
- Need/wish : Use of already existing codes as "reference" (from a reference base still used for some applications). We thus wish to apply codes already used and automatically apply new ones.
We are thinking of using the SemQL query method (to be defined - idea: search for the last code available in the list and "tag" it as "activated" once applied.)
Do you think is a good method / is possible ?
Thanks for your advice!
Best Answer
S
Subham Dixit
said
6 months ago
Hello Rlhostis,
Yes, you can use the Code attribute in the ID generation using the SemQL, but it won't apply to the existing records, it will be only applicable to the newer one that you will create and always take the value of 'code' attribute which you will provide while creating a record, as it's a Primary key so there's won't be 2 same code values exist otherwise it will throw an error.
Thank you.
1 Comment
S
Subham Dixit
said
6 months ago
Answer
Hello Rlhostis,
Yes, you can use the Code attribute in the ID generation using the SemQL, but it won't apply to the existing records, it will be only applicable to the newer one that you will create and always take the value of 'code' attribute which you will provide while creating a record, as it's a Primary key so there's won't be 2 same code values exist otherwise it will throw an error.
Régis L'HOSTIS
- Do you have any recommendations (alert point) when using an identifier from a source system. In connection with this following documentation.
- Need/wish : Use of already existing codes as "reference" (from a reference base still used for some applications). We thus wish to apply codes already used and automatically apply new ones.
We are thinking of using the SemQL query method (to be defined - idea: search for the last code available in the list and "tag" it as "activated" once applied.)
Do you think is a good method / is possible ?
Thanks for your advice!
Hello Rlhostis,
Yes, you can use the Code attribute in the ID generation using the SemQL, but it won't apply to the existing records, it will be only applicable to the newer one that you will create and always take the value of 'code' attribute which you will provide while creating a record, as it's a Primary key so there's won't be 2 same code values exist otherwise it will throw an error.
Thank you.
Subham Dixit
Hello Rlhostis,
Yes, you can use the Code attribute in the ID generation using the SemQL, but it won't apply to the existing records, it will be only applicable to the newer one that you will create and always take the value of 'code' attribute which you will provide while creating a record, as it's a Primary key so there's won't be 2 same code values exist otherwise it will throw an error.
Thank you.
1 person likes this
-
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 276 topics