Summary

Queries differ from reports because they show all the fields for a defined group of records. The records are filtered according to the parameters that you enter in the query. The View Queries tab page contains a list of Query codes and their descriptions.

For example, if you activate a query on the Employees entity for casual employees, then on the View Entities tab you will see employee records for casual employees only.

You can use queries to display only specific types of entity records, but the query applies to that entity only. For example, if you created a query to display only Departments 01 and 02, then you could apply this query to the Departments records. However, it would not affect other entities, such as Employees, which would still display records for all departments. However, if you edited a Department field in an employee's record, then you could select only Departments 01 and 02.

Activating a Saved Query

You are on the Employees | View Queries Grid.

1. Right-click the required query to see the menu.
2. Click Activate Query.

   The results of the query can be viewed on the View Entities tab.

3. Click Deactivate Query to restore the Grid to normal view.

   Important: Always deactivate queries after you use them. If you do not, then other procedures that you complete, such as running payslips, will only use the employees in the query.

Creating Queries

See Create a Query.