addOrCondition not working ...

[Zod]

HI .... as I'm using a scoped application I assume this might be the reason why the xx.addOrCondition gives me an error in the logs ... ;-(

" Cannot find function addOrCondition in object [object GlideRecord]."

Could you please help me doing what is done here ... just without requiring the   xx.addOrCondition ?

....

var xx = new GlideRecord("sn_customerservice_channel_config");

var arrXX = email.to.split(',');  

var k = 0;

for (var n = 0; n < arrXX.length; n++) {

if (k == 0) {

xx.addQuery('email_address', arrXX[n]);

k++;

} else {

xx.addOrCondition('email_address', arrXX[n]);

}

}

xx.query();

....

Thank you!!!

[Shishir Srivast]

I believe you can do with addEncodedQuery() query as well.http://wiki.servicenow.com/index.php?title=GlideRecord#addEncodedQuery

http://wiki.servicenow.com/index.php?title=GlideRecord#addEncodedQuery

[Zod]

Hi Shishir,

not sure if this could work - at least I see not how.

I have 2 arrays with emails and need to check if arrXX is in "email_address" of table "sn_customerservice_channel_config" ...

...

[Shishir Srivast · Accepted solution]

Can we try in this way. see if this helps.

var k = 0;

var queryString;

var arrXX = email.to.split(',');

var xx = new GlideRecord("sn_customerservice_channel_config");

for (var n = 0; n < arrXX.length; n++) {

if (k == 0) {

queryString = 'email_address=' + arrXX[n];

k++;

} else {

queryString = queryString + '^ORemail_address=' + arrXX[n];

}

}

xx.addEncodedQuery(queryString);

xx.query();

[Zod]

This one has worked!!!

THank you!!!!!

[Zod]

shit ... no it didn't.

Did not check all ... rowcount does not tell the right number