you need to do 2 things which I mentioned in my 1st response to your question
1) advanced ref qualifier
a) why variable value will be random? You said it's a select box so it should have choices in it, you can use that.
You can use this, for x1 choice value you can have a query
javascript:var variableValue = current.variables.please_select_the_fileserver_where_the_shared_folder_is_located.toString() ; var query; if(variableValue == 'x1') query = 'u_descriptionLIKEread^u_descriptionLIKE' + variableValue; query; If you want the same filter for other drop down choices then do this generic
javascript:var variableValue = current.variables.please_select_the_fileserver_where_the_shared_folder_is_located.toString() ; var query = 'u_descriptionLIKEread^u_descriptionLIKE' + variableValue; query; 2) variable attributes - add this
ref_qual_elements=please_select_the_fileserver_where_the_shared_folder_is_located
If my response helped please mark it correct and close the thread so that it benefits future readers.
Hello @Koyel Guha
Hope you are doing well!
Your requirement looks like based on the group, populate the group members. Here, the Group field will select box field(reference field), and the Group member field will be a List collector field.
Please find below the script include and call the script include from your list collector type variable, and change it according to your requirement:
var displayData = Class.create();
displayData.prototype = Object.extendsObject(AbstractAjaxProcessor, {
showGroupmembers: function(groupID) {
var memArray = [];
var grup = groupID;
//var groupID = this.getParameter("sysparm_group");
var grMem = new GlideRecord("sys_user_grmember"); //change the table name
grMem.addQuery('group', grup); // you can add your "read" keyword logic here
grMem.query();
while (grMem.next()) {
memArray.push(grMem.getValue("user").toString());
}
return 'sys_idIN' + memArray.join(",");
},
type: 'displayData'
});Below is the reference qualifier condition on the List Collector type variable:
Here, group_name is the database name of Group field
javascript: new global.displayData().showGroupmembers(current.variables.group_name);Output:
After doing all this stuff, you can use an onchange client script to clear the value on change of the Group field
Thank you!
Hello @Koyel Guha
Please find below the code, which may help you to resolve your problem
var displayData = Class.create();
displayData.prototype = Object.extendsObject(AbstractAjaxProcessor, {
displayKeyword: function(inp) {
var memArray = [];
var input = inp;
var grMem = new GlideRecord("u_jurisdiction");
grMem.addQuery("u_juri_nameLIKE"+ input +"^ORu_juri_nameLIKE" + input); //I used OR operator
grMem.query();
while (grMem.next()) {
memArray.push(grMem.getValue("sys_id").toString());
}
return 'sys_idIN' + memArray.join(",");
},
type: 'displayData'
});Below is the ref qualifier:
javascript: new global.displayData().displayKeyword(current.variables.variable_a);
Here, Variable A is a select box variable. I have custom choices in this field
Output:
Thank you!
