Two queries from a different table from script Include

[DB1]

Hi All,

We have a Script Include with below function:

getUser: function() {

		var loggedIn = gs.getUserID();
		var grgetUser = new GlideRecord('u_m2m_sys_user_cmdb_ci_service');
		grgetUser.addQuery('sys_user',loggedIn);
		grgetUser.addQuery('sys_user.active','true');
		grgetUser.query();
		if(grgetUser.next())
			return true;					

		else
			return false;

	},

Here I was just checking the logged in User has a valid record in the m2m Table.

Now I want to check/include another table's query also.

I am trying to update the code as below:

var loggedIn = 'a301620c4777255075211711e36d4372';
		var grgetUser = new GlideRecord('u_m2m_sys_user_cmdb_ci_service');
		grgetUser.addQuery('sys_user',loggedIn);
		grgetUser.addQuery('sys_user.active','true');
		grgetUser.query();
		if(grgetUser.next())
		{
gs.print(grgetUser.u_cmdb_ci_service);
			var grcheckCI = new GlideRecord('cmdb_ci_service');
			grcheckCI.addQuery('sys_id',grgetUser.u_cmdb_ci_service);
grcheckCI.addQuery('u_self_service_crf','true');
grcheckCI.query();
if(grcheckCI.next)
{
//gs.print('true');
gs.print(grcheckCI.u_self_service_crf);
}
else
{
gs.print("Not enabled false");
}
			
}

this does not go to else part it just validates if but not else. Please help with updating the code right.

Thanks!

@Dr Atul G- LNG @Maik Skoddow @Sainath N @Ankur Bawiskar @Anil Lande 

[Anil Lande]

Hi,

There is typo error:

var loggedIn = 'a301620c4777255075211711e36d4372';
		var grgetUser = new GlideRecord('u_m2m_sys_user_cmdb_ci_service');
		grgetUser.addQuery('sys_user',loggedIn);
		grgetUser.addQuery('sys_user.active','true');
		grgetUser.query();
		if(grgetUser.next())
		{
gs.print(grgetUser.u_cmdb_ci_service);
			var grcheckCI = new GlideRecord('cmdb_ci_service');
			grcheckCI.addQuery('sys_id',grgetUser.u_cmdb_ci_service);
grcheckCI.addQuery('u_self_service_crf','true');
grcheckCI.query();
if(grcheckCI.next()). // next() was spelled incorrectly here
{
//gs.print('true');
gs.print(grcheckCI.u_self_service_crf);
}
else
{
gs.print("Not enabled false");
}
			
}