Commencer un nouveau sujet
Répondu

How to reference a sequence in a custom function, which I will then populate as an attribute in Semarchy?

How to reference a sequence in a custom function, which I will then populate as an attribute in Semarchy?


Meilleure réponse

Follow these steps to generate a sequence value and populate it in an attribute. 

  1. Create a custom sequence in that database.
  2. Call the sequence using sequence.NEXTVAL in your function.
  3. You can then return the next sequence val in your function
  4. Create a new database function in the Semarchy app builder
  5. Once the function is created in Semarchy, create an enricher, which can populate the attribute with the returned value in your function.
1 commentaire

Réponse

Follow these steps to generate a sequence value and populate it in an attribute. 

  1. Create a custom sequence in that database.
  2. Call the sequence using sequence.NEXTVAL in your function.
  3. You can then return the next sequence val in your function
  4. Create a new database function in the Semarchy app builder
  5. Once the function is created in Semarchy, create an enricher, which can populate the attribute with the returned value in your function.
Connexion pour poster un commentaire