Name
global.ReferenceFilterTableSelection
Description
Get Value for Selected Table in Reference Filter
Script
var ReferenceFilterTableSelection = Class.create();
ReferenceFilterTableSelection.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getRecords: function(){
var gp = [];
var table = this.getParameter("sysparm_reference_table");
var conditions = this.getParameter("sysparm_reference_conditions");
var grp = new GlideRecordSecure(table);
grp.addActiveQuery()
if(conditions)
grp.addEncodedQuery(conditions);
grp.setLimit(10000);
grp.query();
while(grp.next()) {
if (!grp.getDisplayValue(grp.getDisplayName()))
continue;
gp.push(this.getRecordJSON(grp))
}
var result = this.newItem("result");
result.setAttribute("record", JSON.stringify(gp));
return JSON.stringify(gp);
},
getRecordJSON: function(gr){
var record = {};
record.key =gr.getDisplayValue("sys_id");
record.value = gr.getDisplayValue(gr.getDisplayName())
return record;
},
type: 'ReferenceFilterTableSelection'
});Sys ID
ff9f44e3c3002200bde4beae82d3ae3a