Uppercase: query parameter value in API from Visual Builder

Summary

Uppercase: query parameter value in API from Visual Builder

Content

Hi All,

I have an input text (inpVar) and the API with 10 attributes, out of which Name attribute is there.

Now whatever I type in the input text, by taking the value.toUpperCase() method I am able to convert this into uppercase.

But I want to convert the data coming from the Name attribute and then compare these in query parameter something like:

"UPPER(Name) ='" + $page.variables.inpVar.toUpperCase() + "'"

UPPER (Name) isn't working. Is there a way to convert the query parameter values to uppercase?

Please let us know.