This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi guys... Whats the best way to find the employees with no transactions?

```var employeeSearchObj = search.create({
   type: "employee",
   filters:
   [
   ],
   columns:
   [
      search.createColumn({
         name: "entityid",
         summary: "GROUP",
         sort: search.Sort.ASC,
         label: "Name"
      }),
      search.createColumn({
         name: "internalid",
         join: "transaction",
         summary: "COUNT",
         label: "Internal ID"
      })
   ]
});
var searchResultCount = employeeSearchObj.runPaged().count;
log.debug("employeeSearchObj result count",searchResultCount);
employeeSearchObj.run().each(function(result){
   // Check if Employee Has Zero Transactions
   if(result.getValue({
         name: "internalid",
         join: "transaction",
         summary: "COUNT"
      }) === 0){
//Do something
}
   return true;
});```

Not sure if best, but off the top of my head.

You could add a filter of `["count(transaction.internalid)", "equalto", "0"]` and only return employees with no transaction rather than returning all employees and filtering out those with transactions.