Partial matching of reference type field values with addQuery()

[N_Y_1014]

Thank you for your help.

I am trying to accomplish a requirement to display a record in a custom table when the department name in the record is a partial match to the logged in user.

An example would be as follows
If the department name in the record and the department name of the logged in user contain "ABC", then the record should be displayed to the logged in user.
Example:
Department name in which the record is registered: ABC DDD
Department name of the logged-in user: ABC EEE

I am also trying to employ a pre query business rule as a function to use.

I have taken the following approach, but am stumped by the means to partially match the department name in the custom table with the department name of the logged in user.

Best regards.

(function executeRule(current, previous /*null when async*/) {

	// Add your code here
	//Get department name of logged-in user
	var depSysid = gs.getUser().getDepartmentID();
	
	//Query with the department's sys_id in the cmn_department table matching the department's sys_id of the logged-in user
	var dep = new GlideRecord('cmn_department');
	dep.addQuery('sys_id', depSysid);
	dep.query();
	
	var depName;
	
	//Stores department records matching the depName
	if(dep.next()){
		
		//Department name "ABC EEE" is stored
		depName = dep.name;
	}
	
	//Cut out the division name "ABC"
	var dep_cut = depName.substr(0, depName.indexOf('C') + 1);
	
	//I want to run a query with a partial match between the custom_department_name field and the depName value in a custom table
	var ctm = new GlideRecord('custom_table');
	ctm.addQuery('custom_department_name', //Processing here is unclear);
	ctm.query();
	
})(current, previous);

[Sandeep Rajput]

Ah! so custom_department_name is again a reference field on your custom_table, I was not aware as you didn't share the table structure. Nonetheless, you can mark my answer correct as it managed to address 80% of the requirement for you.