question Re: Get the count of records in a reference variable in Developer forum

Get the count of records in a reference variable

Kumar60 — Tue, 28 Apr 2020 12:19:37 GMT

Hello All,

I am using a refernce qualifier on Group variable which works fine.

Now I want to count the "number of groups" that group variable is showing.If my group(s) count is one then I need to set the one group in the group field and it should be read only.if the group count is greater than 1 then user will select the groups.

How to achieve this?Below is my reference qualifier code:

Reference qualifier:javascript: new getgroupcontext().getgrpcontext(current.variables.role2);

Re: Get the count of records in a reference variable

Jaspal Singh — Tue, 28 Apr 2020 12:30:48 GMT

Can you try something as below (untested).

var getgroupcontext = Class.create();
getgroupcontext.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getgrpcontext : function(role)
{

//var role = this.getParameter('sysparm_query');
var countis='';
var x;
var groups = [];
var gr = new GlideRecord('sys_group_has_role');
gr.addQuery('role.name',role);
gr.query();

while(gr.next())
{
//gs.log("@362363"+gr.group+"NOWROLE"+gr.role.name);
countis=gr.getRowCount();
if(countis==1)
{
x=gr.group.sys_id;
}
else
{
groups.push(gr.group);
x='sys_idIN' + groups.toString();
}
return x;
},
type: 'getgroupcontext'
});

Re: Get the count of records in a reference variable

Kumar60 — Wed, 29 Apr 2020 07:55:04 GMT

Hello Jaspal,

The below script with logs,giving the count as 2(which is expected),but while returning the groups sys_id it is giving only one sys_id instead of 2.Any idea?Attached log for reference.

If I have a rowcount of 1,I need to set the single group in the group variable by using client script(glideajax),how to achieve this?

var getgroupcontexttest = Class.create();
getgroupcontexttest.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getgrpcontexttestf : function(role)
{

//var role = this.getParameter('sysparm_query');
var countis='';
var x=[];
var groups = [];
var gr = new GlideRecord('sys_group_has_role');
gr.addQuery('role.name',role);
gr.query();

while(gr.next())
{
gs.log("@362363"+gr.group+"NOWROLE"+gr.role.name);
countis=gr.getRowCount();
gs.log("@362363 the COUNT is " + countis);
if(countis==1)
{
gs.log("@362363 the COUNT is only one ");
x=gr.group.sys_id;
//x='sys_idIN' + gr.group.sys_id;
gs.log("@362363 the value of X is " + x);
}
else
{
gs.log("@362363 the COUNT is more than one ");
groups.push(gr.group);
x='sys_idIN' + groups.toString();
}
gs.log("@362363 the last return of X is " + x);
return x;

}
},
type: 'getgroupcontexttest'
});

Re: Get the count of records in a reference variable

Jaspal Singh — Wed, 29 Apr 2020 08:15:36 GMT

Can you replace else part with below in code above.

else
{
x=groups.push(gr.group.sys_id);
}

For populating it on the field with the value you need to write a client scirpt that would set it. Look for link for a check.

Re: Get the count of records in a reference variable

Kumar60 — Wed, 29 Apr 2020 11:31:31 GMT

Hi Jaspal,

I tried with multiple ways,but it seems not working.

Re: Get the count of records in a reference variable

Ankur Bawiskar — Wed, 29 Apr 2020 11:53:29 GMT

Hi Kumar,

you cannot set value to group variable if script include returns 1 value; reference qualifier will help in restricting the records and not setting the value

you can use this approach:

1) use onChange client script and use GlideAjax and check if only 1 group exist with that role; if yes then return that and set the value; if more than 1 return sys_ids

Same function you can use for both the purpose; one from ref qualifier and one from GlideAjax

2) keep the reference qualifier as it is -> this will help users to see restricted groups if more than 1

Note: I assume the role2 variable is a string variable

Client Script: onchange client script on role variable

function onChange(control, oldValue, newValue, isLoading) {
	if (isLoading) {
		return;
	}

if(newValue == ''){
g_form.clearValue('group_variable');
return;
}

	var ga = new GlideAjax('u_userInfoAjax');
	ga.addParam('sysparm_name', "getGroups");
	ga.addParam('sysparm_role', newValue);
	ga.getXMLAnswer(function(answer){
	
        if(answer != ''){
        g_form.setValue('group_variable', answer);	
        }

	});

}

Script Include:

var getgroupcontext = Class.create();
getgroupcontext.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getgrpcontext : function(role)
{

var role = JSUtil.nil(role) ? this.getParameter('sysparm_role') : role;

var groups = [];
var gr = new GlideRecord('sys_group_has_role');
gr.addQuery('role.name',role);
gr.query();

if(gr.getRowCount() == 1)
return gr.getValue('group');

else{
while(gr.next())
{
groups.push(gr.getValue('group'));
}
return 'sys_idIN' + groups.toString();
}
},


type: 'getgroupcontext'
});

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Re: Get the count of records in a reference variable

Kumar60 — Thu, 30 Apr 2020 04:24:34 GMT

Hello Ankur,

If the count is 1,still the value is not getting set.I checked with logs,the answer value we are getting in client script is only 'sys_idIN'.
If the count is more than 1,scenario is working fine.

I tried in background script,I am getting the single groups sys_id,if the count is one.

Re: Get the count of records in a reference variable

Ankur Bawiskar — Thu, 30 Apr 2020 04:38:10 GMT

Hi Kumar,

can you share your script include?

when onchange is working what you are getting in answer variable?

Did you print that?

Regards
Ankur

Re: Get the count of records in a reference variable

Kumar60 — Thu, 30 Apr 2020 05:18:41 GMT

My script include is below.When printing answer in client script only 'sys_idIN' is printing.

var getgroupcontexttest2 = Class.create();
getgroupcontexttest2.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getgrpcontext : function(role1)
{

var role = JSUtil.nil(role1) ? this.getParameter('sysparm_role') : role1;

var groups = [];
var gr = new GlideRecord('sys_group_has_role');
gr.addQuery('role.name',role1);
gr.query();

if(gr.getRowCount() == 1){
return gr.getValue('group');
//return gr.group.sys_id;

//return gr.group.getDisplayValue();
}

else{
while(gr.next())
{
groups.push(gr.getValue('group'));
}
return 'sys_idIN' + groups.toString();
}
},

type: 'getgroupcontexttest2'
});

Client script as follows:

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
if(newValue == ''){
g_form.clearValue('group2');
return;
}

var ga = new GlideAjax('getgroupcontexttest2');
ga.addParam('sysparm_name', "getgrpcontext");
ga.addParam('sysparm_role', newValue);
//ga.getXMLAnswer(function(answer){This is also trowing the same output.just tried splitting the getXMLAnswer as below.
ga.getXML(GetDetails);
function GetDetails(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
alert("@362363 answer from Script include is " + answer);
if(answer != ''){
//if(answer){This returns the same result
g_form.setValue('group2', answer);

//g_form.setReadOnly('group2',true);
}
}
//});
//Type appropriate comment here, and begin script below

}

Re: Get the count of records in a reference variable

Ankur Bawiskar — Thu, 30 Apr 2020 05:57:36 GMT

Hi Kumar,

please update script as below; you are storing role in this variable so use that

gr.addQuery('role.name',role);

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Re: Get the count of records in a reference variable

Kumar60 — Thu, 30 Apr 2020 06:37:50 GMT

I tried doing that by updating gr.addQuery('role.name',role);

Now,If the count is two i.e more than one,the alert answer in client script is giving 2 sys_id's.

But if the count is one then the alert for answer is throwing null.

Tried by updating the while loop as below,in this case it's setting the group value if the count is one.

But if the count is 2,then only one sys_id its giving in the alert.

So as per my understanding,what ever the return is there after while(gr.next()) that is only giving the accurate result!

Re: Get the count of records in a reference variable

Ankur Bawiskar — Thu, 30 Apr 2020 12:59:10 GMT

Hi,

got your point;

1) in case when there are more than 1 it is returning the group sys_id and setting

2) but when more than 1 it is entering while and forming the array and returning something like this 'sys_idINsys_id1,sys_id2'

so what you can check is whether the answer variable contains a string with 32 characters it means it is single sys_id

when there are more than 1 records it would be a string with length more than 32

var ga = new GlideAjax('u_userInfoAjax');
	ga.addParam('sysparm_name', "getGroups");
	ga.addParam('sysparm_role', newValue);
	ga.getXMLAnswer(function(answer){
	
        if(answer != '' && answer.toString().length == 32){
        g_form.setValue('group_variable', answer);	
        }

	});

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Re: Get the count of records in a reference variable

Ankur Bawiskar — Mon, 04 May 2020 03:56:28 GMT

Hi Kumar,

Let me know if that answered your question.

If so, please mark my response as ✅ correct & 👍 helpful so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Regards
Ankur

Re: Get the count of records in a reference variable

Kumar60 — Mon, 04 May 2020 12:07:49 GMT

Hello Ankur,

A small change in the code returning the expected results.

below is the modified line code:

*****Code change in Script Include*****

gr.query();

if(gr.next()){//wrap in if,will fix the issue

if(gr.getRowCount() == 1){
return gr.getValue('group');
//return gr.group.sys_id;

//return gr.group.getDisplayValue();
}

}//If condition close

******Code change in Script Include******