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.

[Chitowndivaus]

Thank you for responding...

When a user selects another customer from the check box, the selection is suppose to replace the default name of 'DECA' with whatever name was selected as shown in the two databases.  So, if the user selects 'Cedar Fair', 'DECA' is replaced by 'CEDAR FAIR'.

Hope this helps.

Chitowndivaus

[danilang]

Hi @Chitowndivaus 

The problem is probably in one of your two action action tools.  Can you post the configuration of both of those?

Dan 

[Chitowndivaus]

Morning...

There's only one action tool for the macro and one for workflow:  

I have another workflow that works identical to this one and it returns the correct information.

Thanks.

[danilang]

Hi @Chitowndivaus 

Unfortunately, the second image that you posted doesn't show the entire config of the action tool.  Are you replacing the entire string or just the "Albertsons..." clause?

Dan

[Chitowndivaus]

You're right...I apologize for that...here you go

[danilang]

Hi @Chitowndivaus 

How is your List box configured?  Is it still in Select tool mode or have you configured it to Generate a custom list.  In Select tool mode it will generate string similar to  "option1=true,option2=false,option3=true"  To properly work with your filter, you need to have it set Generate custom list with the default options to get "option1","option3"  

If it is configured correctly, try adding a Message tool between the unique and the macro with the message displaying the field value.  This will spit out a message that you can view in the results window when you run it as an app.  This will help you debug where it may be failing

Dan