topic Re: Interface Tools - Action not updating values in Alteryx Designer Desktop Discussions

Interface Tools - Action not updating values

Hal-Matt — Thu, 15 Aug 2019 09:57:17 GMT

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

Re: Interface Tools - Action not updating values

MichalM — Thu, 15 Aug 2019 10:13:44 GMT

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

Re: Interface Tools - Action not updating values

rkapoor — Thu, 15 Aug 2019 10:14:24 GMT

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

This may resolve your issue.

Re: Interface Tools - Action not updating values

Hal-Matt — Thu, 15 Aug 2019 10:25:10 GMT

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

Re: Interface Tools - Action not updating values

Hal-Matt — Thu, 15 Aug 2019 10:27:13 GMT

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

Re: Interface Tools - Action not updating values

rkapoor — Thu, 15 Aug 2019 10:28:58 GMT

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

Re: Interface Tools - Action not updating values

Hal-Matt — Thu, 15 Aug 2019 10:38:12 GMT

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

Re: Interface Tools - Action not updating values

MichalM — Thu, 15 Aug 2019 10:39:57 GMT

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

Re: Interface Tools - Action not updating values

Hal-Matt — Thu, 15 Aug 2019 10:54:58 GMT

@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