Interface Tools - Action not updating values

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. Debug Debug Macro MacroWorkflow

Report GUI.zip

Interface Tools

Accepted answers

MichalM

@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.

All comments

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')

rkapoor

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

@rkapoor 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" Annotation 2019-08-15 112606.png

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235