Set Dependent for Custom Fields

[Jaeik Lee]

I made 2 different custom fields in sc_task table.

field1 : 

u_zassignmentid

Reference(sys_user_group)

field2 :

u_zassigneeid

Reference(sys_user)

I set field2 dependent that lookup field1 value like Assignment Group and Assigned to.

But it did not work.

Why it does not work? How can i do?

Thank you for answer.

[Anand Kumar P]

Hi @Jaeik Lee ,

In assigned to field dependent value use assignment_group 
or
You can write reference qualifier on assignment group and use below script

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

	
	getMembers : function(groupId){
		gs.log("group",groupId);
		var id = [];
	var gr = new GlideRecord('sys_user_grmember');
		gr.addQuery("group",groupId);
		gr.query;
		while(gr.next()){
			id.push(gr.getValue("user"));
		}
		
		gs.log('sys_idIN+id.join();' +"sys_idIN"+id.join());
		return "sys_idIN"+id.toString();
	},
    type: 'UserGroup'
});

javascript:new UserGroup().GetMembers(current.assignment_group);

or 
https://www.servicenow.com/community/developer-articles/catalog-items-make-assigned-to-dependent-on-... 

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand

[Stefan Reichelt]

I tried that in my PDI, and I got it working at first attempt for the field2 -> field1 relation.

I just put "u_zassignmentid" into the "Dependent Field" of field2, and then I could always get the right users that were in the previously selected group. I would just beautify it with a UI Policy and clear the user field when the group field is emptied.

Is your setup anyhow different? If it still doesn't work, can you maybe share a few screenshots of the field dictionary entries?

[Jaeik Lee]

Hi. there is screen shot of my works.

[Tai Vu]

Hi @Jaeik Lee 

Can you share what you have done so far and highlight any aspects that didn't function as expected?

Cheers,

Tai Vu