Start a new topic

How to pass the batch id in a workflow start event to call a procedure

Hi All,


Am looking for options to pass the batch id in the workflow start evert of type "Start Form batch" and call a DB procedure to get only the records matching a condition to be part of the workflow task. I couldn't find the Batch ID value to pass it to the procedure and also how would multiple records matching condition be used part of the workflow. Also how multiple records matching the procedure logic, identified to be part of the workflow tasks, should I return the list of MDM IDs matching the condition from procedure, so they can be picked.

Would really appreciate if you could share some insights and suggestions on getting this done.


1 Comment

Hello Vinoth,


In the semql editor, I can see the BatchID field:


However, what you might mean is how to recover a certain BatchID.

Maybe were you expected to find it in the variables?


To be honest, I don't see the use case that would warrant you to filter on a dynamic BatchID.

> Could you please maybe tell us more about your requirement?


Secondly, if you have any custom functions that you need to use for the condition on record, then you can find them in the option panel, as per highlighted on my screenshot below:

But remember, that any customization introduces maintainability and performances complexities.


If your question was more specific on a precise use case, please detail here what you'd like to achieve.


If need be, we can convert this forum into a ticket to continue the conversation there or forward it to our amazing Professional Services team who are much better equipped to guide you in those implementation questions.


Thank you and have a good day.

Login to post a comment