I'm assuming a lot of details about your requirement here, so let me know if your specifics aren't in line. For this example I have a reference variable on a catalog item. The variable is referencing the core_company table in my OOTB Orlando PDI. This is what it looks like with no reference qualifier.
Now I have added an Advanced Reference qualifier
javascript:new Companies().getFilteredCOs();
I'll skip to the end and show the results first when I return records that do not start with 'ACME'.
To accomplish this, create a Script Include with the same name and function referenced in the qualifier. Make sure the Client callable box is checked. Here is the script I used for this simple example. You could also pass in the 'does not start with' text string from another field/variable as a function parameter.
var Companies = Class.create();
Companies.prototype = {
initialize: function() {
},
getFilteredCOs:function(){
var colist = [];
var dnswText = 'ACME';
var gr = new GlideRecord('core_company');
gr.query();
while(gr.next()){
if(gr.name.indexOf(dnswText) == -1 || gr.name.indexOf(dnswText) != 0){ //string not found or not at beginning of Name field
colist.push(gr.sys_id.toString());
}
}
return 'sys_idIN' + colist.join(',');
},
type: 'Companies'
};
