
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2017 10:20 AM
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!!!
Solved! Go to Solution.
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2017 11:22 AM
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();

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2017 11:31 AM
this one does not work.
Will not find all entries ...
string 1 ( mail1,mail2,mail3) .... string 2 (mail1, mail1, mail1, mail2, mail5)
rowcount should find 4 entries ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2017 11:32 AM
Did you try encodedQuery() ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2017 11:36 AM
Try this. This should work
var xx = new GlideRecord("sn_customerservice_channel_config");
var arrXX = email.to.split(',');
qc = xx.addQuery('email_address', arrXX[0]);
for (var n = 1; n < arrXX.length; n++) {
qc.addOrCondition('email_address', arrXX[n]);
}
xx.query();
if (xx.next())
{
gs.addInfoMessage('Record exists');
}
Please mark this response as correct or helpful if it assisted you with your question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2017 11:53 AM
qc?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2017 12:06 PM
Corrected qc.
var xx = new GlideRecord("sn_customerservice_channel_config");
var arrXX = email.to.split(',');
var qc = xx.addQuery('email_address', arrXX[0]);
for (var n = 1; n < arrXX.length; n++) {
qc.addOrCondition('email_address', arrXX[n]);
}
xx.query();
if (xx.next())
{
gs.log('Record exists');
}
Please mark this response as correct or helpful if it assisted you with your question.