Secure Query is a desktop query and reporting tool that enables you to quickly and easily generate or modify requests for specific information. For example, sometimes you just need answers in a hurry to prepare for a meeting or to help make projections. Secure Query makes it easy to get the information you need.
Using Secure Query you can select which fields to output, sort results in ascending or descending order, build record filters, and group and summarize fields. When finished you can choose to output the query as a report, spreadsheet, text file, or database table. You can also create and save a virtually unlimited number of queries and reuse these queries any time you need the information.
Use Ad Hoc Reporting Security to restrict the database files and fields available to a security group using Secure Query . Ad Hoc Reporting Security lets you assign an access level to each field contained in your Sage HRMS databases.
Setting a group’s Ad Hoc Reporting Security Level works in conjunction with setting Ad Hoc Reporting Security. When you set up group security, (Select Setup > System > Group Security link), you establish an access level that determines which fields in the Sage HRMS system databases are able to be accessed by the security group’s users whenever they use Secure Query .
Refer to Set Up Sample Queries to guide you through the process of defining your queries. In addition, sample queries are provided in sample data for each installed product. If you are working with live data, you might want to see how a query works before you create it. Switch from live data to sample data to practice with the sample queries before creating your own custom queries.
Note: Queries created in sample data cannot be copied or imported from sample data to live data.
From the Query Main page you can: