Subscribe
Accepted Solution

How to create a query user input

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

Re: How to create a query user input

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. 

Re: How to create a query user input

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

Re: How to create a query user input

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