Unable to set Assignment group

[Kunal33]

Hi Team,

We have a record producer in which we need to set Assignment group based on Functional identifier fields. This functional identifier field is a reference field and refer to x_bii_learning_req_functional_identifier_list table and 

x_bii_learning_req_assignment_lookup store both functional identifier and Assignment group.

We have created a script include:- 

var BIIB_Assignment_lookup = Class.create();
BIIB_Assignment_lookup.prototype = {
initialize: function() {},

getAssignmentGroup: function(functident) {
var assigngrp;
var grp = new GlideRecord("x_bii_learning_req_assignment_lookup");
grp.addQuery("active", true);
grp.addQuery("functional_identifier.full_name", functident);
//grp.addQuery('sys_id', functident);
grp.query();
if (grp.next()) {
assigngrp = grp.group;
gs.log("kunal1"+assigngrp);
}
return assigngrp;

},

type: 'BIIB_Assignment_lookup'
};

x_bii_learning_req_assignment_lookup- this table contains the Assignment group name and functiona identifier values.

and 

var assignmentgroup = new x_bii_learning_req.BIIB_Assignment_lookup().getAssignmentGroup(funident);
current.assignment_group = assignmentgroup;

We have call this in Record producer script.

but unable to get assignment group based on functional identifer

[Saurabh Gupta]

Hi,

Try to run below script in background.

function getAssignmentGroup(functident) {
var assigngrp;
var grp = new GlideRecord("x_bii_learning_req_assignment_lookup");
grp.addQuery("active", true);
grp.addQuery("functional_identifier.full_name", functident);
//grp.addQuery('sys_id', functident);
grp.query();
if (grp.next()) {
assigngrp = grp.group;
gs.log("kunal1"+assigngrp);
}
getAssignmentGroup("give a input as per functions argument: functident")

//Please give me a screenshot as well

[Kunal33]

var abc="Legal & Compliance (CORP-LGL)";
var assigngrp;
var grp = new GlideRecord("x_bii_learning_req_assignment_lookup");
grp.addQuery("active", true);
grp.addQuery("functional_identifier.full_name", abc);
//grp.addQuery('sys_id', functident);
grp.query();
if (grp.next()) {
assigngrp = grp.group;
gs.info("kunal1"+assigngrp);
}

I have tried this way and below are the output:

[Saurabh Gupta]

Use below code in your script include

 

var BIIB_Assignment_lookup = Class.create();
BIIB_Assignment_lookup.prototype = {
getAssignmentGroup: function(functident) {
var assigngrp="";
var grp = new GlideRecord("x_bii_learning_req_assignment_lookup");
grp.addQuery("active", true);
grp.addQuery("functional_identifier.full_name", functident);
grp.query();
if (grp.next()) {
assigngrp = grp.getValue('group');
}
gs.info("checkinglogs: "+assigngrp)
return assigngrp;
},

type: 'BIIB_Assignment_lookup'
};

[Kunal33]

Thanks for replying, will check with this way also.