convert to lower case

joshishree · ‎09-08-2017

var gr = new GlideRecord('sys_user');

gr.addQuery('first_name.toLowerCase()',another_variable);

gr.addQuery('last_name.toLowerCase()',lastnewname);

gr.query();

if(gr.next())

{

}

here another_variable and lastnewname are in lower case

I want the table fields also to be in lower case is it possible and how to do it

Jaspal Singh · ‎09-08-2017

Hi Bhagyashree,

No need of using .toLowerCase() as query does not look for case sensitivity unless we give value directly.

Shishir Srivast · ‎09-08-2017

column name will always be in lower case.

harishdasari · ‎09-08-2017

Hi Bhagyashree,

Try this link below, might help you.

Thanks

Dave Smith1 · ‎09-08-2017

Bhagyashree Joshi wrote:


gr.addQuery('first_name.toLowerCase()',another_variable);

gr.addQuery('last_name.toLowerCase()',lastnewname);

as others have said, "first_name" is in lower case anyway, so no need to apply this method
as you've included the method in the quotes, the addQuery() function will see that all as literal text.

What's the use case behind this? Are you trying to lower-case some text before including it as a search parameter?