Skip to main content

Custom Query: Set the query to exclude one or more employees

How to filter staff by name not to be included? How do I exclude a foreign employee's salary before submission to the bank?

Updated over 2 months ago

How to exclude one or more employees from the data (example employee id = 1234):

  1. Go to the Core or Payroll module and click Query Setup.

  2. Click New and create a new Query ID.

  3. Enable Use Custom Query and click the three-dotted button

  4. In the left panel, scroll up and double-click on the Employee ID.

  5. Employee.EmployeeId will be displayed in the formula pane.

  6. Type NOT IN into the formula bar. The formula pane will now display as Employee.EmployeeId NOT IN

  7. Type open bracket.

  8. In the Select drop-down list, select the employee. The formula pane will now display as Employee.EmployeeId NOT IN ('1234'

  9. Type a close bracket. The formula pane will now display as Employee.EmployeeId NOT IN ('1234')

  10. If you have more than one employee ID to exclude, then include a comma in between the employee IDs.

  11. Click Save and apply this query.

Related Articles
Custom Query: Query one employee in EasyPay
Custom Query: Create a random employee query
Custom Query: Set the custom query to filter by some departments
Custom Query: Combine 2 or more custom queries
Custom Query: Exclude employee query is not working
Did this answer your question?