Start a new topic
Answered

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?


Best Answer

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 Comment

Answer

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.
Login to post a comment