topic Functions in a user input query? in Active IQ Unified Manager Discussions

Functions in a user input query?

dblackwe — Wed, 04 Jun 2025 15:18:47 GMT

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.

Re: Functions in a user input query?

sinhaa — Sun, 19 Mar 2017 15:51:21 GMT

@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

Re: Functions in a user input query?

dblackwe — Sun, 19 Mar 2017 16:11:34 GMT

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.