Calling stored procedures with workflow parameters
What problem are you facing?
I have a daily process that triggers a stored procedure. This stored procedure should fire some inserts or updates depending of one of the workflow parameters.
What impact does this problem have on you/your business?
Reprocessing data with hardcoded values instead of dinamic values it is not a clean solution and we force the client to execute on a database (which requires DBA permissions and bureaucracy)
Do you have any existing workarounds? If so, please describe those.
I was thinking in CMD scripting but t is not a nice and clean solution.
Do you have any suggestions to solve the problem? Feel free to add images if this helps.
If Pre and Post sql statements we should be add workflow parameters, similar with the '@' that we use on automations.
This we let us be more flexible with the user.