Values not displaying in listcollect

[Emp 53]

Hi All,

My requirement is based on group i need to display users details in list collector.  for fetching this i written below script.

Script Include:

groupMember: function() {

var id = this.getParameter('sysparm_mem');

var idList = [];

var removemember = new GlideRecord('u_member');
removemember.addEncodedQuery('name=' + id);
removemember.query();
while (removemember.next()) {
idList.push(removemember.member.toString());
}

return 'sys_idIN' + idList.join(',');
},

client script:

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}

g_form.clearValue('select_members_to_remove');

var ga = new GlideAjax('Details');
ga.addParam('sysparm_name', 'groupMember');
ga.addParam('sysparm_mem', newValue);
ga.getXML(callBackFunction);

function callBackFunction(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
alert(answer);

var collectorName = 'select_members_to_remove';
var filterString = answer;

var myListCollector = g_list.get(collectorName);
myListCollector.reset();
myListCollector.setQuery(filterString);
}
} in alert i can able to see all details related to group but after that it's not working and below result displayed in listcollector field.

[Emp 53]

Hi Tai,

let me explain my requirement clearly. I have 2 custom tables 1) Internal Group & internal Member.

In internal group i have all group details. In member table i have 3 variables 1) Group Name 2) Member 3) Member email

Group name is Reference field remaining 2 string variables.

because why i created string field is in same variable i need to capture member and group info. because for new group they can be add member & group as well.  In that case only facing issue with displaying data.

[Tai Vu]

Hi @Emp 53 

From my understanding about your use case, you're trying to set the reference qualifier for the list collector variable, which will display members of the selected group. 

"My requirement is based on group i need to display users details in list collector."

So you can base on the script then apply it for your custom tables. Just make sure to change the variable and field name.