Get DB data into Interface Tools dropdown and use it as dynamic input for next query

[kulkarnivinay]

Hello Experts,

I am trying to get data from a database table. I have a client table that has Client Name and Client ID. I need to get the Client Name in an dropdown and then pass the ID as dynamic input to another query to get data from a different table based on the ID. Below is a screenshot of my workflow. When I run this workflow as an Analytic app, I get the drop down with the list of all the clients but after I select the Client Name, I am expecting to see the Client Name and ID but instead I get an message - There were no output files. Can someone please let me know what am I missing here.

[Rags1982]

Hi @kulkarnivinay 
If I'm thinking correctly, what you want is the name AND value in the same column in order for the output to be correct. 

So, for instance, the input into your drop down tool will need to show Client Name:Client ID. 

The Client name will be the 'Name' and the Client ID will be the value that is passed out of the action tool to update your filter. 

Similar to how you would create a manual list within the drop down tool. 

Hope this helps?