To filter employees randomly, please do as follows:
Go to the Core or Payroll module and click Query Setup.
Click New and enter the Query Name, eg, Random Employee.
Enable the Use Custom Query and click the three-dotted button.
On the right panel of the Custom Query, double-click on Employee Name.
On the left panel, after the Employee.EmployeeName type IN.
Click the open bracket, then in the drop-down list, select the employee.
Type a comma after an employee is selected.
Type a close bracket after the last employee selection.
Click Save and close the window.
Click Apply , and it should appear like this Employee.EmployeeName IN ( 'Amy Tan May Ling', 'James Tan', 'Norman Tan' )
