Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Drop downs are not getting updated in the gallery

swapsingh2712
8 - Asteroid

Hello,

 

I've created few analytics apps and uploaded in the gallery, so these apps contains drop down tools and their values are coming from the alteryx database files which we've stored in the shared drive.

 

Now these alteryx database files are connected to the teradata and we run the scheduled jobs so that the alteryx database files which are connected to drop downs are keep getting updated.

 

But somehow the updated vales are not showing up for the dropdown tools. 

 

Please advise if I need to make any changes to the workflows.

 

BR

swapsingh 

3 REPLIES 3
mbarone
16 - Nebula
16 - Nebula

First thing to make sure is that you did NOT send that drop down box as an asset when you uploaded it to the Gallery.  Second thing is to make sure the drop down box configuration is using a full UNC path.  

swapsingh2712
8 - Asteroid

@mbarone 

 

While uploading the workflow, I've converted the file path to UNC and also from the manage workflow asset option I've unchecked all the drop down files except the output tool.

 

Do I need to make any more changes?

 

mbarone
16 - Nebula
16 - Nebula

Not that I'm aware of.  As long as the drop down files are unchecked when sending to the Gallery, everything should work fine - the app is run it should reach out directly to the source.  I have several apps that do just that and have had no issues.  

Just to further confirm, you have drop down box "A", and it's configured as "External Source - Must contain NAME && VALUE fields (can be relative path)"

And in the Properties you have the full UNC to some YXDB?  And that YXDB is updated via some other process?
And there are some values that are in that YXDB right now, but that don't show up in the drop down?

If all the above is correct, then I'm not sure why it won't work.