Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

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

Dropdown list from SQL Table in Analytic App on Gallery

nicolasdeldalle
7 - Meteor

Hello, 

 

I'm building an Analytic App that I need to publish on my Gallery, and the app needs to show some dropdowns tools that need to be connected to a SQL Server table (the options of the drop down tool should vary depending on the SQL table).

 

For example, I have a drop down tool in my App that should be connected to the a table in my SQL Server instance, so that the end user can select which information he wants from the SQL table, and then continue running the App. 

 

I configured my drop down tools with External Source and my query works fine when I run it from outside the Gallery (as a regular Analytic App), but whenever I try to run it from the Gallery, the drop down do not show the options (it stays empty). 

 

OBS: I have already configured my SQL Server connection to my Gallery and have access to it (I managed to write data in my DB from the Gallery Analytic App). 

 

This is how I configured my Drop Down tool with a List Values from an External Source:

 

nicolasdeldalle_2-1576259575030.png

 

And this is the result I get from the regular Analytic App running from my server, which shows that the drop down is reading the SQL table: 

 

nicolasdeldalle_0-1576259336056.png

 

When I publish my App on the Gallery (which is on the same server), the drop down options don't appear: 

nicolasdeldalle_3-1576259658832.png

 

Is there any way my App on the Gallery will connect to the SQL Server instance and show the drop down options from the live SQL table?

 

Thanks in advance! 

13 REPLIES 13
JordyMicheal
11 - Bolide

Could you show a picture of the workflow?

Sounds correct to me though

nicolasdeldalle
7 - Meteor

Hi JordyMichael, 

 

This is the picture of my WF: 

 

nicolasdeldalle_1-1576262633705.png

Since the picture itself doesn't say much, I'll detail a little bit more: 

 

Each one of the interface tools is supposed to update the first line of a specific column in my text input. 

I'm using almost the same SQL query for each interface tool except that it looks into a different table / field in my SQL Server, and updates different columns. 

 

Hope this will make it clearer. 

 

Thanks ! 

 

 

JordyMicheal
11 - Bolide

Could you try adding an "AS" in the SQL statement.

select field AS name and AS value.


It is the same, but let's rule things out.

 

nicolasdeldalle
7 - Meteor

The result is exactly the same

JordyMicheal
11 - Bolide

OK, so it's the way it's populating then.

 

I believe you need to connect it out of the Green Arrow, not the lighting bolt for that connection

nicolasdeldalle
7 - Meteor

Which green arrow do you mean? I think the problem is more related to the connection between the Gallery and my SQL Server, since the app works fine on my server outside of the Gallery.

JordyMicheal
11 - Bolide

That's the only other problem I could see

.

It's between Alteryx Gallery querying under a generic username that doesn't have access to the Table if I were to guess.
How you have it is correct

nicolasdeldalle
7 - Meteor

I found a similar post regarding this issue: 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Interface-DropDown-does-not-populate-o...

 

Any help would be much appreciated! 

 

Thanks

WilliamR
Alteryx
Alteryx

Hello,

I manage to reproduce your behaviour so I confirm there is something weird.

As a workaround, you can populate your drop down from an input data tool connected to your DB.

Just remember that you have to transpose your field in order to have it in the drop down. It works on my Gallery.

 

WilliamR_0-1576486075918.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.