The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to reigister at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

User Input Queries in WFA 2.0


I remember seeing a discussion a few months back that mentioned an upcoming feature of 2.0 that would allow more than one value to be returned, so you could display the main value to be used in the workflow as well as additional values to be used to make a decision. Did this feature make it to the released product? I couldn't find mention of it in the release notes or the reference manual. I currently use a SQL query to generate a list of aggregates based on the controller name the user has submitted, but I would like to also display the commit rate and the resource pool they belong to, as those are two major factors we take into consideration when deciding where to provision storage.



HI Tim,

Yes there is a provision in WFA 2.0 to make user input queries to select multiple values depending on some input parameters.

In the preferences tab of the workflow, you will find a tab called user inputs, here you can mention the type as query for the user input and provide your query selecting the parameters that you need like below:



    ' : ', AS 'Aggregate',

    aggregate.size_mb AS 'Total Size (MB)',

    aggregate.used_size_mb AS 'Used Size (MB)',

    aggregate.available_size_mb AS 'Available Size (MB)',

    COUNT( AS 'Volume Count'

In this case, the first column will be the user input value and the additional columns will help you choose.

On execution of this query in the user input window of preview/execute, you will find a drop down list of the eligible values take from the db.

Hope this helps.


NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner