Interface DropDown does not populate on the server with updated value from database

Hi,

I am facing two issues while working with the Drop down menu (naming as Actual App). First, I need to display the drop down menu with a list that is connected to a live database. The functionality of the Actual app is to modify one value and update the database. Secondly, while running the app next time, the drop down menu should display the modified list (changed before via App).

I have used 3 types of configuration for this issue, although they work fine on my local machine, none of them execute successfully on the server.

Configuration 1: The drop down menu is connected to a LIVE database connection, it fails to display any thing on the server.

Configuration 1.PNG

Configuration 2: The drop down is forced to connected to a dynamic rename tool that connected to a live database connection, it displays the old list, not the new one after previous run.

Configuration 2.PNG

Configuration 3 : Used a Chained app (user wont see the app) that would run and create a .yxdb file, the Actual App is using drop down to retrieve the .yxdb file to display the list. This configuration displays a list but does not update with modified value after the previous run.

Configuration 3.PNG

None of these work successfully in the server.

Any suggestions?

Thanks,

Manidipa

Workflow

Accepted answers

All comments

afv2688

Hello @ManidipaB ,

Had the same issue. It doesn't work on the gallery. The way I resolved it was to create an simple app which writes first the file containing the names and values of the dropdown menu (Even if you do manually the updates of the dropdown menu create at least an input connected to the output for refreshing the list on the gallery). Then, on the designer interface (control + alt + d) deselect the 'show output results' and click the function 'On success run another app' and select the actual app. This is the configurattion I'm using right now. I know its not perfect but at least it works.

Cheers

paulhurley

Just registering interest in this topic - I have the same issue. It appears that server caches the values that were present in designer the last time I ran the workflow in designer. It NEVER checks the sql server for these values once the workflow is saved to the alteryx server.

trying to update an existing record by selecting it from a drop down list, which is connected to a database.

My workflow (below) isnt great - I have tried moving things around, reconnecting the same table directly to the dropdown etc etc.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703