Edit group members Catlog Item

[abhiyadav2001]

Hi,

I have a requirement where Manager should be allowed to edit the group members ( add / remove ) of the groups that he / she is managing.

I have created below variables in Catalog item.

1. Reference : User Assignment group table (sys_user_group) : This displays the groups which are managed by 'logged   In' user. I put a reference qualifier here to display particular groups.

2. List Collector :

I am thinking to use 'Group Edit' form / page on the Catalog item ( I think this will make my work easier) , pls find the attached screenshot

This form displays the 'existing users' of the groups on the right side and Other users on the left.

Is it possible to have that complete page in the Catalog item ? Where to find that page ?

Is there any other approach you think will be easier ?

Thanks,

Abhijeet

[Hichem]

Hi,

Are you saying that I will need the   g_form.setValue method to populate the list collector ?
How can we do that for the leftbucket and rightbucket ?

Thanks

[Kalaiarasan Pus]

setValue method doesn't appear to be working. I was able to find a workaround for this but the below solution is a violation of ServiceNow best practices and would not work on portal and might break in future.

Below is the script include function that does the heavy lifting. It retrieves the group members, new filter condition for the list collector and formats the data as JSON

getGroupMembers : function(){

  var group = this.getParameter('sysparam_groupID');

  var user_array = [];

  var query = 'active=true';

  var getMembers = new GlideRecord('sys_user_grmember');

  getMembers.addQuery('group',group);

  getMembers.query();

  while(getMembers.next())

  {

  var user_Obj = {};

  query= query + '^sys_id!=' + (getMembers.getValue('user'));

  user_Obj.key=getMembers.user.getDisplayValue();

  user_Obj.value=getMembers.getValue('user');

  user_array.push(user_Obj);

  }

  var filter_Obj = {};

  filter_Obj.key = 'list_filter';

  filter_Obj.value = query; //This is the new filter of list collector.

  user_array.push(filter_Obj);

  return (new JSON()).encode(user_array); //JSON formatted string

  }

The onchange script of the group variable fetches the information related to the group and populates the fields. Since the list collector is essentially a select box, I am using Jquery to fill out the options (groups members)

var glideAjax = new GlideAjax('Common_Utilities');

  glideAjax.addParam('sysparm_name','getGroupMembers');

  glideAjax.addParam('sysparam_groupID',newValue);

  glideAjax.getXMLWait();

  jQuery('#group_members_select_1').empty();

  var response =(glideAjax.getAnswer());

  var jsonData = (response.evalJSON());

  for( var i=0 ; i < (jsonData.length)-1 ; i++)

  jQuery('#group_members_select_1').append(jQuery("<option></option>").attr("value",jsonData[i].value).text(jsonData[i].key)); //Populate the options

//sets the new filter for the list collector.

  group_membersg_filter.reset();

  group_membersg_filter.setQuery(jsonData[(jsonData.length)-1].value);

  group_membersacRequest(null);

[Kalaiarasan Pus]

Reworked the code a bit and was able to eliminate JQuery and filter part.

Below is the optimized script.

Script include :

getGroupMembers : function(){

  var group = this.getParameter('sysparam_groupID');

  var user_array = [];

  var query = 'active=true';

  var getMembers = new GlideRecord('sys_user_grmember');

  getMembers.addQuery('group',group);

  getMembers.query();

  while(getMembers.next())

  {

  var user_Obj = {};

  query= query + '^sys_id!=' + (getMembers.getValue('user'));

  user_Obj.key=getMembers.user.getDisplayValue();

  user_Obj.value=getMembers.getValue('user');

  user_array.push(user_Obj);

  }

  return (new JSON()).encode(user_array); //JSON formatted string

  }

Onchange Client script:

var varName = 'group_members'; //slush bucket variable name

  var glideAjax = new GlideAjax('Common_Utilities');

  glideAjax.addParam('sysparm_name','getGroupMembers');

  glideAjax.addParam('sysparam_groupID',newValue);

  glideAjax.getXMLWait();

  var leftBucket = gel(varName + '_select_0');

  var rightBucket = gel(varName + '_select_1');

  rightBucket.options.length = '0';

  var response =(glideAjax.getAnswer());

  var jsonData = (response.evalJSON());

  for( var i=0 ; i < (jsonData.length)-1 ; i++)

  addOption(rightBucket,jsonData[i].value, jsonData[i].key);

  sortSelect(rightBucket);

  leftBucket.onchange();

[Hichem]

kalai it's working pretty well !!

However, something strange, for every group, I always get one missing member, fro example hardware group have 7 members, I have 6 members in the rightbucket....

I'll try to investigate what's going wrong with the retreived data.

Thanks for your precious help !

[Kalaiarasan Pus]

Oops. Change this like

  for( var i=0 ; i < (jsonData.length)-1 ; i++)

to

  for( var i=0 ; i < (jsonData.length) ; i++)