Start a new topic

How to call a function in an Enricher

I'm needing to call a custom function in an Enricher.  Below is how I have it set up.  I have simplified the SQL for testing purposes.  I can't get a value to return and update the attribute value when running the stepper.


Semarchy DB Function...

image


Enricher SemQL to update an attribute called "dummy"...

image


Stepper to trigger Form Enricher...

image


SQL Function...

image



Hello Matthew,


The process seems to be fine by calling a function, you need to check the function now.

Can you please check if this function is working by calling it? 

Also you can test it on a form field by just calling it with :v_loadid as a parameter?


Thank you

Subham Dixit

So the function is actually working.  When I save the record in authoring mode and it returns to the collection, the value is actually there.  What I was expecting to happen is when in authoring mode and I'm changing values the enricher would run(on change box is selected in the stepper), call the function, and update the field on the screen.    What am I missing?

Hello  Matthew ,


Can you please send us your enricher SS like below :-

Here are screenshots of the enricher and the stepper.

image

image


Hello  Matthew ,

Can you please check once you finish stepper data is updating in Attribute or not . Please check in Business view after stepper finished. 

Toshish,

When the stepper is finished the attribute has been updated correctly.  Meaning it ran the enricher. And the corresponding tables were updated(SA, GD,...).   What I would like to happen is , the value returned from the enricher would be reflected on the screen while still in authoring mode.  The enricher should run multiple times(on data change) and as the values of the form are updated the result of the enricher would change on the screen.  


Thanks,

Matt

Hello  Matthew , 

For this you need to add filter condition. when you made changes in attributes that are used in filter condition then enricher will check condition and update data quickly on UI. You can try this.


Login to post a comment