Batch Macro Not Working

Chitowndivaus

Good afternoon All...

I have a Batch Macro where it doesn't seem to be accepting the parameter that is being passed.  

After a customer/customers is selected, the data is supposed to be passed to the Batch Macro, a query is ran then the results are passed out to the main workflow.  Instead the Batch Macro is running and sending out the default data.  I have no idea why or how to fix it.  This is a part of a chained app, so I'm not going to put all of parts on here--just the part that I'm having problems with:

This is the macro.  The default is DECA.  Below it is the query that is supposed to pull customer volume which it does for the default customer, DECA.  Both the 'Input Data Source Template' and  the 'Modify SQL Query' have the same query:

The parameter is suppose to be reading data from one of the tables below which have the same data.

The Control Parameter is supposed to be using the value from one of the above tables to send the parameter to the macro.

Instead of getting the new customer as a result, I'm still getting the default data which is incorrect:

Any ideas would be helpful...

Thanks.

pedrodrfaria

Hi @Chitowndivaus 

If I understood it corretly, the issue is that you are replacing "DECA", using the Action, but your function inside of the dynamic input uses "DECA" as a variable, so when updated, "DECA" does not exist anymore and actually you would have a different variable being inputted.

I hope this helps, let me know if you have any questions.

Pedro.