To combine your query for 2 or more conditions, please complete the following steps:
Go to the Core or Payroll module and click Query Setup.
Click New and enter the query name.
Enable the Use Custom Query checkbox and click on the 3 dotted button.
In the Custom Query window, on the right panel, double-click on the item you want in the query, such as Department.
On the left panel, after the Employee.DepartmentId type IN
Click on the open bracket and in the drop-down list, select the department.
Each time you select a department, it has to be followed by a comma.
Type a comma followed by the next department selection.
The last department is followed by the close bracket.
Add in AND after the bracket and choose another item, such as Employee.PositionId
If you want to have another query, repeat the step above.
Click Save, close the window and click Apply.
It should appear like this Employee.DepartmentId IN ( 'IT' , 'HR n Admin' ) AND Employee.PositionId IN ( 'Assistant', 'Executive')