Discussions
nlobjSearchFilter gives error:Invalid Search Join ID
Hi,
We are using Advanced job tracking module.
I am using server suite script to search for the sales order that has a certain job/project id in its job field. When i set up a join filter on the job field-
filters[0] = new nlobjSearchFilter( 'job', 'project', 'equalTo', prjId, null);
.....
var searchresults = nlapiSearchRecord('salesorder', null, filters, columns);
Then it gives me error:Invalid Search Join ID.
Can anyone guide me as to why i am getting this error and how to search on the job field of a sales order?
Thanks