Interface Tools - Action not updating values

[Hal-Matt]

I am trying to create an app where I can use interface tools so users can enter sku numbers, a start date and an end date, and have results returned to them.

However, my interface tools don't seem to be updating the values on the filter tool within the macro. I have tried multiple combinations of Update Value, Update Value with formula, using the replace a specific string option and selecting an attribute through the Action configuration menu, all to no avail.

I know my values are being passed into the macro and that the control parameters are set to the right fields (see screenshots). But I cannot work out why the action tool isn't updating the filter values.DebugMacroWorkflow

[MichalM]

@Hal-Matt 

I was just wondering why you think the filters within the macro are not updated? Is it because you don't see any records returned? 

A possible issue could be how you're building out the filter for Article Nos using in. This approach requires each Article No to be wrapped in quotes which is not the case in your workflow

('11111111','2222222') rather than ('11111111,2222222')

[RishiK]

Have you tried replacing the Control Parameter inputs, in the Macro, with Macro Inputs?

This may resolve your issue.

[Hal-Matt]

---

@MichalM wrote:

@Hal-Matt 

I was just wondering why you think the filters within the macro are not updated? Is it because you don't see any records returned? 

A possible issue could be how you're building out the filter for Article Nos using in. This approach requires each Article No to be wrapped in quotes which is not the case in your workflow

('11111111','2222222') rather than ('11111111,2222222')

---

Good spot, this definitely was an issue, but it hasn't fixed my workflow. 

And yes, because I'm not getting any values returned, but maybe it is a problem with the macro.

[Hal-Matt]

---

@RishiK wrote:

Have you tried replacing the Control Parameter inputs, in the Macro, with Macro Inputs?

This may resolve your issue.

---

When I try this it tells me "the macro input cannot be used as a question input for this action type"

[RishiK]

Ok, did @MichalM 's suggestion work with the control parameters set in the macro?

[Hal-Matt]

---

@RishiK wrote:

Ok, did @MichalM 's suggestion work with the control parameters set in the macro?

---

No it didn't, but I've added into my input data some records that ought to be selected by the dummy values in the filter that my action ought to be updating, and they aren't being returned either.

[MichalM · Accepted solution]

@Hal-Matt 

There are couple of things I'd check

1. The data type of your Article No. For this type of filter to work, the Article No needs to be a string.

2. I'd change the way the date filter is configured to Basic and then use the action tool to replace the Operand - see below. I've tested with these 2 changes and the macro works as expected.

[Hal-Matt]

---

@MichalM wrote:

@Hal-Matt 

There are couple of things I'd check

1. The data type of your Article No. For this type of filter to work, the Article No needs to be a string.

2. I'd change the way the date filter is configured to Basic and then use the action tool to replace the Operand - see below. I've tested with these 2 changes and the macro works as expected.

Changing the date filter to Basic and then using action to replace the Operand worked here!  Thanks Michael