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

correct syntax for query using LIKE with predefined variable?


trying to use like in a query referencing a predefined variable and cant get the syntax right.

SELECT AS VolumeName

  FROM cm_storage.volume v, cm_storage.cluster c, cm_storage.vserver vs

WHERE     ( = vs.cluster_id)

       AND ( = v.vserver_id)

       and like '${LastVol}'

       order by desc

limit 1

Anyone know if this can be done, and if so, what the syntax is?



Hi Stephen,

That is the correct syntax. It is working for me.

What kind of error is being thrown, if any?


Hi Stephen:

Where are you using/testing this query? In WFA or using it outside WFA?

If you are using in WFA which version of WFA are you using?

As 'ag' replied, it is syntactically correct, WFA is not complaining.

If using WFA, are you trying to use it in a user input query or you are using in a filter?




Hey guys, it must have been something stupid. I tried in another workflow and the syntax worked correctly

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