topic How to create a query user input in Active IQ Unified Manager Discussions

How to create a query user input

arndt — Thu, 05 Jun 2025 06:35:45 GMT

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

goodrum — Sat, 04 Feb 2012 02:14:03 GMT

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

arndt — Sat, 04 Feb 2012 02:21:28 GMT

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

goodrum — Sat, 04 Feb 2012 02:24:38 GMT

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