Hi,
I have custom record A with a multi-select field and custom record B with the a multi-select field, both are using the same list as values. What I need to do is create a suitescript search which use custom record A as the master record and sets the values to search for, and searches all custom record B records for those with matching field value..
I have a script search that works but it finds all record B's that have 1 matching value from the custom record A field, where I want to have it match both fields. IS this possible?
//For Testing Purposes var newRec = nlapiLoadRecord('customrecord_user_testers_record',2); var disabilities = newRec.getFieldValues('custrecord_usr_tstr_disability'); //Define search Filters var filters = new Array(); filters[0] = new nlobjSearchFilter('custrecord_usr_tstr_disability', null, 'anyof', disabilities)); //Define Columns var columns = new Array(); columns[0] = new nlobjSearchColumn('custrecord_usr_tstr_disability'); columns[1] = new nlobjSearchColumn('custrecord_usr_tstr_first_name'); columns[2] = new nlobjSearchColumn('custrecord_usr_tstr_last_name'); columns[3] = new nlobjSearchColumn('custrecord_usr_tstr_email'); columns[4] = new nlobjSearchColumn('custrecord_usr_tstr_tester_type'); //execute search var searchresults = nlapiSearchRecord('customrecord_user_testers_record',null,filters,columns); var x=0