Hello all,
We are retrieving a row data from Database using query entity.
In query filter we have a condition to get a row data.
Example
a!queryFilter( field: "name", operator: "=", value: ri!name )
Database having name value as "Arunkumar" I need to get the row data irrespective of case sensitive like (ri!name = "arunkumar" or "ArunKumar" or "ARUNKUMAR")
Any suggestion on this !!!
Thanks,
Arunkumar C
Discussion posts and replies are publicly visible
Hi Arun,
You need to convert your ri!name into the desired format.
For eg. your query filter will look like
a!queryFilter(field: "name",operator: "=",value: upper(left(ri!name,1))&lower(right(ri!name,len(ri!name)-1)))
You can also make use of the proper function to achieve this like:
a!queryFilter(field: "name",operator: "=",value: proper(ri!name))
Agree !!! thanks Aditya for your input !!! We are looking for irrespective of any combination of string(upper/lower) it should be match with database value and returns the row.