How to call a function in an Enricher : xDM

M

Matthew Ammons

started a topic 5 months ago

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...

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

Stepper to trigger Form Enricher...

SQL Function...

Best Answer

T

Toshish Chauhan said 4 months ago

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.

S

Subham Dixit

said 5 months ago

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

M

Matthew Ammons

said 5 months ago

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?

T

Toshish Chauhan

said 5 months ago

Hello Matthew ,

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

M

Matthew Ammons

said 5 months ago

Here are screenshots of the enricher and the stepper.

T

Toshish Chauhan

said 5 months ago

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.

M

Matthew Ammons

said 5 months ago

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

T

Toshish Chauhan

said 4 months ago

Answer

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.