Need to filter for stockroom reference field

[Atchamma D]

Hi All,

On the form level I have one of the field called "stockroom" and referring to alm_stockroom table.

And I have one field on the form level that is "Requested for" based on this requested for field I need to filter the stockroom field with stockroom record == active AND requestor is a member of the stockroom assignment group field this condition.

Please any one provide me the input,

Thanks in advance,

Atchamma D

[Vishal Birajdar]

Hi @Atchamma D 

Is your requirement for catalog item or on Native UI form...??

[Atchamma D]

Hi @Vishal Birajdar 

 for catalog item 

[Vishal Birajdar · Accepted solution]

Hi @Atchamma D 

You can follow the below steps :

Step 1 : Create script include 

Name : stockRoomUtils

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

getStockroom : function(requested_for){

/*1. Declare the variables */
var result;
var groupArray =[];

/*2. get the groups which user is member of */
var grMem = new GlideRecord('sys_user_grmember');
grMem.addQuery('user',requested_for);
grMem.query();

while (grMem.next()){

	/*3. get the groups in array */
	groupArray.push(grMem.group.name);

}

/*4. set the result with query */
result = 'assignment_group.nameIN' + groupArray.toString();   //you can add your query here like for active  'active=true^assignment_group.nameIN' + groupArray.toString(); 

/*5. Return the result*/
return result;
},


    type: 'stockRoomUtils'
};

Step 2 : on Stockroom variable write Advance reference qualifier

javascript: new stockRoomUtils().getStockroom(current.variables.requested_for);  // use your variable name

Output : 

In my case Abel tutor is member of "App Engine Admins" assignment group & this group is added to stockroom

Hope this helps....!!!

[Atchamma D]

Thanks @Vishal Birajdar its working!!!