Check case sensitive in addQuery filter condition

[sana11]

Hi All,

I have a reference field in my catalog form, on choosing of values fetching data from another table. Here I have duplicate names for some records but case sensitive is different. So I just want to get result data only to the name which I passed.

For example.

var gr= new GlideRecord('location');

gr.addQuery('country','INdia'); //should return exact results of INdia not india,INDIA and whatever is available in table.

gr.Query();

Can anyone suggest some ideas ?

Thanks!

[sana11]

what will matches = filter.match(currentRecord, true); do here? Because I just tried only with  filter.setCaseSensitive(true);

[Jason174]

GlideRecord queries are not case sensitive.  You have to add another check like GildeFilter as you suggest below.

Recently ran into this same issue when GlideRecord would match these two:

KnvZfZ7vAde

KnvZfZ7vAdE

[Ankur Bawiskar]

Hi,

addQuery() is doing a case insensitive search; so you want case sensitive search?

addEncodedQuery() is also case insensitive search

Regards
Ankur

[sana11]

Yea I want case insensitive search. Even I tried with grBS.setCaseSensitive(true); but its not working.

[sana11]

I hope this article will helpful to me ,but am confused with the code .Can you please show me the same for my code?