Dynamic List of Values as a report parameter

Hi,

I'm having some issues with the Dynamic List of Values as a report parameter.

When I run the workflow on Alteryx designer, the dynamic list of values added on the workflow works fine, but when I publish the report in Alteryx portal, the dynamic list of values is not refreshed.

As a workaround, I have to run the workflow in Alteryx designer, once the dynamic list of values is refreshed I have to publish the report.

How can I fix this issue to get the dynamic list of values refreshed without running the workflow in Lateryx designer and then publishing the workflow?

i've attached the workflow as your reference.

I appreciate your comments and help on this.

Regards,

@glombard

BP Robot Statistics Report.yxwz

Developer Tools

Accepted answers

csmith11

apathetichell made a great point.

What you really need to use in your scenario is a Chained App.

The First App will Query your Database and Create a List containing the Name and Value to be used in your drop downs. (Set this path relative to your workflow) Simple YXDB file is fine.

Once First app runs without errors it'll kick off the Second App.

The Second App is your main Process with your drop downs that are populated by the first app. You'll need to use the external file option and reference the DropDownValue.yxdb file created in first app. (Reference this path as the same folder as your workflow as well.) Ensure both workflows are in the same location.

To upload a chained app to Gallary you only need to publish the first App and the second app will be published with it:

Notice how it is included as an Asset when publishing the first app.

For additional information see this discussion here:

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Publishing-chained-apps-to-Gallery/td-p/760572

All comments

apathetichell

I'm not quite following you but it sounds like you want chained apps - one app to refresh values, one app to run a report. I think you are skipping something like a UI component that changes fields in the report?

glombard

Hi @apathetichell

Thank you for your answer.

As you can see on the attached file, the Resource Query and Process Name Query I use to get the options or parameters to get the information on the report.

If I run the workflow on Designer, if there is a new Resource or Process Name, that value is populated on the list of values or options. When I publish the workflow in a private gallery, if there is a new Resource or Process Name, the new value is not populated on the workflow in a private gallery published.

If I want to get the new value populated on the workflow published on the private gallery, I have to run the workflow in Designer to get the new values populated and publish the workflow on the private gallery.

When you say " I think you are skipping something like a UI component that changes fields in the report", what you mean?

Regards,

@glombard

apathetichell

Where are you getting the new values in your drop downs from? Like you say that they change on your designer - but take a step back and walk through the process....

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703