Is the contains filter case-sensitive when filtering strings?

[KS18]

Is the contains filter case-sensitive when filtering strings?

[Hitoshi Ozawa]

Hi,

Not an ideal solution but check the following question.

https://community.servicenow.com/community?id=community_question&sys_id=33008721db98dbc01dcaf3231f96...

[Hitoshi Ozawa]

A better solution is to use GlideFilter.

https://developer.servicenow.com/dev.do#!/reference/api/rome/server/no-namespace/c_GlideFilterScoped...

Below will not return any result because there is "Abel" and no "abel"

var now_GR = new GlideRecord('sys_user');
now_GR.query();

var condition = 'first_name=abel';
var filter = new GlideFilter(condition, 'filterCondition');

// Disable case-sensitive filtering
filter.setCaseSensitive(true);

while (now_GR.next()) {
  if (filter.match(now_GR, true))
     gs.info(now_GR.getDisplayValue());
}