Quick Jump Menu
Advanced Search Search the Knowledgebase
Customize a query for various of employee
Author: Susan Lai Reference Number: AA-00720 Views: 1774 Created: 2014-05-04 23:10 Last Updated: 2014-05-04 23:10 0 Rating/ Voters

Scenario:

Customize a query for various of employee


Solution:

i.         Go to Payroll → Query Setup 

ii.        Click on New → Key in the Query Name

iii.        Tick on the box Use Custom Query and click on the  button

iv.        Double click on the Employee ID on the list at your left handed area → select the sign not equal to [!=]→ select the employee ID → select ‘And’ to add on more employee Id if you wish to.

v.        The end result should be similar as below:

Employee.EmployeeId  != 'A0001' OR

Employee.EmployeeId  != 'A0002' OR  

Employee.EmployeeId  != 'A0003' OR 

Employee.EmployeeId  != 'A0004' OR

Employee.EmployeeId  != 'A0005'

vi.        Click on Save to apply the query.

Rss Comments
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below: