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:
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:
When I publish my App on the Gallery (which is on the same server), the drop down options don't appear:
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!
Solved! Go to Solution.
Could you show a picture of the workflow?
Sounds correct to me though
Hi JordyMichael,
This is the picture of my WF:
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 !
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.
The result is exactly the same
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
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.
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
I found a similar post regarding this issue:
Any help would be much appreciated!
Thanks
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.