Active IQ Unified Manager Discussions

How to create a query user input

arndt
3,355 Views

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

1 ACCEPTED SOLUTION

goodrum
3,355 Views

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. 

View solution in original post

3 REPLIES 3

goodrum
3,356 Views

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
3,355 Views

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
3,355 Views

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

Public