question Re: Comma separated values not returning from script include to client script in ServiceNow AI Platform forum

Comma separated values not returning from script include to client script

Chenab Khanna — Mon, 28 Sep 2020 15:49:49 GMT

I have a string variable where users enter names by comma separating( field name - colleagues1) and i have another variable which will store the email address of those names by comma separated.

I wrote a catalog client script and script include for this. It worked fine when the variable (colleagues1) where users are selected is a list collector but if the variable is a string, it isnt going in the loop and always just returning email address of 1st user selected.

Please find the script include -

I checked, the values are coming correctly from client script and the for loop is also running fine.

Works first time, but subsequently, it isn't going to else condition

Re: Comma separated values not returning from script include to client script

Ankur Bawiskar — Mon, 28 Sep 2020 16:03:51 GMT

Hi,

please update script as below

getEmailSharePoint: function(){

var userName = this.getParameter('sysparm_s');

var arr = userName.toString().split(',');

var arr1 = [];

var userRec = new GlideRecord('sys_user');

userRec.addActiveQuery();

userRec.addQuery('email', 'IN', arr);

userRec.query();

while(userRec.next()){

arr1.push(userRec.email.toString());

}

return arr1.toString();

},

Regards
Ankur

Re: Comma separated values not returning from script include to client script

Chenab Khanna — Tue, 29 Sep 2020 07:59:15 GMT

Its giving blank value

Re: Comma separated values not returning from script include to client script

Jaspal Singh — Tue, 29 Sep 2020 08:22:43 GMT

Hi Chenab,

Can you replace

if(i==0)

{

gp=gr.email;}

else

{

gp=gp+','+gr.email;}

with

gp=gr.email+','+gp;

Also, var gp=''; instead of var gp=' ';

Re: Comma separated values not returning from script include to client script

Ankur Bawiskar — Tue, 29 Sep 2020 08:49:02 GMT

Hi,

Did you check the query is getting satisfied or not

please share your complete script for reference

Try adding logs

getEmailSharePoint: function(){

var userName = this.getParameter('sysparm_s');

var arr = userName.toString().split(',');

var arr1 = [];

var userRec = new GlideRecord('sys_user');

userRec.addActiveQuery();

userRec.addQuery('email', 'IN', arr);

userRec.query();

gs.info('Row Count is' + userRec.getRowCount());

while(userRec.next()){

arr1.push(userRec.email.toString());

}

gs.info('Array of email is' + arr1.toString());

return arr1.toString();

},

Regards
Ankur

Re: Comma separated values not returning from script include to client script

Chenab Khanna — Tue, 29 Sep 2020 09:15:18 GMT

Hi.

I checked the row count is 0. Please find the script -

var FetchEmailSharePoint = Class.create();
FetchEmailSharePoint.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getEmailSharePoint: function() {
var gp = ' ';
var ar = [];

var userName = this.getParameter('sysparm_s');
var count = userName.toString().split(',');

// for (var i = 0; i < count.length; i++) {

var gr = new GlideRecord('sys_user');
gr.addActiveQuery();
gr.addQuery('name', 'IN', count);
gr.addQuery('email', 'CONTAINS', '@companyemail'); //the email ids should contain a //specific text
gr.query();
gs.log("row count " + gr.getRowCount());
while (gr.next()) {
//ar.push(gr.email);

/* if (i == 0) {
gp = gr.email;
}
else{
gs.log("else condn "+gp);
gp = gp + ',' + gr.email;
}*/
ar.push(gr.email.toString());
}

// gs.log("finish array "+ar.join(','));
// return gp;
gs.log("return value " + ar.toString());
return ar.toString();
},
type: 'FetchEmailSharePoint'
});

One thing, the value coming from client script (sysparm_s) contains names of users by comma separated.

Re: Comma separated values not returning from script include to client script

Ankur Bawiskar — Tue, 29 Sep 2020 09:49:29 GMT

Hi,

are those values the name field of sys_user then the script shared by me should work fine

Regards
Ankur

Re: Comma separated values not returning from script include to client script

Chenab Khanna — Tue, 29 Sep 2020 09:58:53 GMT

Hi. I am getting blank -

Email ids for add members field should give email ids of those 3 names.

Also, row count returned 0

Re: Comma separated values not returning from script include to client script

Chenab Khanna — Tue, 29 Sep 2020 10:36:12 GMT

No Luck

Re: Comma separated values not returning from script include to client script

Ankur Bawiskar — Tue, 29 Sep 2020 10:51:20 GMT

Hi,

are you using the script I shared or the one which you posted in the question

if you are using script I shared please share complete client script and script include function

Regards
Ankur

Re: Comma separated values not returning from script include to client script

Chenab Khanna — Tue, 29 Sep 2020 10:53:44 GMT

I used the one you shared.

Re: Comma separated values not returning from script include to client script

Ankur Bawiskar — Tue, 29 Sep 2020 11:09:52 GMT

Hi,

since you informed the row count is 0 so it means the query is not happening

the variable colleagues1 is string type and holds the name so you should query with the name field

Did you check exact name is present in the sys_user table

getEmailSharePoint: function(){

var userName = this.getParameter('sysparm_s');

var arr = userName.toString().split(',');

var arr1 = [];

var userRec = new GlideRecord('sys_user');

userRec.addActiveQuery();

userRec.addQuery('name', 'IN', arr); // see change here

userRec.query();

gs.info('Row Count is' + userRec.getRowCount());

while(userRec.next()){

arr1.push(userRec.email.toString());

}

gs.info('Array of email is' + arr1.toString());

return arr1.toString();

},

Regards
Ankur

Re: Comma separated values not returning from script include to client script

Chenab Khanna — Tue, 29 Sep 2020 11:29:12 GMT

Its still 0 @Ankur Bawiskar

I tried below script include -

TThis works fine for first name. I am able to get email id of first user name i have put but unable to get subesquent. I checked, loop is running fine. I am even getting count[i] separately but not why it get stuck inside while. I tried putting if instead of that while but still not working

Re: Comma separated values not returning from script include to client script

Sajilal — Tue, 29 Sep 2020 11:29:56 GMT

Hi Chenab,

Try playing around with the addQuery which could be causing the issue.

gr.addActiveQuery();
//gr.addQuery('name', 'IN', count); //comment this
gr.addQuery('email', 'CONTAINS', '@companyemail');

Re: Comma separated values not returning from script include to client script

Ankur Bawiskar — Tue, 29 Sep 2020 11:47:42 GMT

Hi,

might be some space in the name

please try this and trim the value

gr.addQuery('name', count[i].trim());

Also did you check those users are having the email with @ whatever your query is

Regards
Ankur

Re: Comma separated values not returning from script include to client script

Chenab Khanna — Tue, 29 Sep 2020 12:00:06 GMT

It works now. Thanks

Re: Comma separated values not returning from script include to client script

Ankur Bawiskar — Tue, 29 Sep 2020 12:05:05 GMT

@Chenab Khanna

Nice to know.

Please mark my response as correct and helpful to close the thread so that others can be benefited by this.

Happy learning.

Regards
Ankur