Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
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

Functions in a user input query?

dblackwe

I want to be able to include one of my fucntions in a query for user input.  Is this possible and if so what is the formating?

 

I tried 'where vserver.name like '%getSVM(${svm})%' but that didn't work (the function takes a customer name, converts it to a two letter code, so the vserver would have that two letter code in it, thus the like %%.

 

I also tried '%{getSVM(${svm})}%' which also didn't work.

2 REPLIES 2

sinhaa

@dblackwe

 

...the function takes a customer name, converts it to a two letter code

 

-------------

 

The WFA MVEL fuctions can't be called inside a mysql query.  I suggest you use MYSQL fucntions to get this done instead of WFA  fucntions.

 

Whatever logic you are using to convert the provided customer name into 2 letter code, it must be possible using Mysql fuctions. 

 

See here.

 

If you can't figure it out, provide your Query and the MVEL fuction and I can give it a try.

 

 

sinhaa

 

 

 

 

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

dblackwe

Thank you so much for the response.  That is upsetting but understandable.  I will simply go forward with a user entered volume name instead of a dropdown list.  Thank you for the offer to try and figure it out for me, but you have already been more than helpful responding on a weekend.

Announcements
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
Public