How to create a query user input

[arndt]

Hi all,

I'm probably missing something simple here, but I need a little help on how to make a user input be a drop down box via a query.  I see some workflows that do this, but what I don't see is where you define what the query string is and how it is associated to the variable that you will define as a query in the user input.  Any pointers would be appreciated!  Thanks,

Mike

[goodrum · Accepted solution]

User Inputs are controlled in the Preferences section of the Workflow.  From here you can set the Type to Query and then set the Value to an actual SQL Query.  This will create a drop down of values. 

[arndt]

Ha, I new it was something simple...just double click on the "Values" column to enter the SQL statement.  Thanks for the quick reply!

[goodrum]

Absolutely... I happen to be sitting here working on some new workflows for the next Pirate Pack