Secure Query Select Fields

The Select Fields tab enables you to limit the results that are returned in your query to only those records that you are interested in. The Select Fields tab lists previously saved fields for the selected query.

Select Fields

1. From the Select Fields  tab, click the Select Fields button. The Select Fields to Show in Query dialog box opens.
2. The Fields to pick from list depends upon the tables you have selected from the Select Data To Use in Query dialog box. The Fields to include in query list shows those fields you selected.
3. From the Fields to pick from list box, double-click or use the SHIFT and CTRL keys to highlight the fields you want to include in the query, and then click the Select button to move them to the Fields to include in query list box. They appear in the order in which you selected them. This is the order in which Sage HRMS displays the fields in your query. If you want to remove one or more fields from the Fields to include in query list, highlight them and click Remove or double-click them, to move them back to the other list.
4. To change the order of the fields, move your cursor over the button to the left of the field until you see a two-headed arrow. Press your left mouse button and drag the field to the desired position. Release the mouse button. The field moves to the new position and the other fields automatically reorder to accommodate the moved field.
5. Click OK after you have selected the appropriate fields. The Query Main page opens.

Additional Data

1. From the Select Fields tab, click Additional Data. The Select Data To Use in Query dialog box opens.
2. From the Choose Employee Information tab, select the type of information you want to include in the query from the Master Table. To define the fields in your query, you must know which Sage HRMS pages contain the fields you need. The pages you will always use contain fields from the Master Table. The Employee Master Table contains all the primary data for an employee in Sage HRMS, Time Off, and Sage HRMS Train.
3. If you want all the fields from the Master Table available to choose from, click Advanced. The Advanced Field Options dialog box opens.
4. Select Make all Employee Master Table fields available for this query and click OK. The Select Data To Use in Query dialog box opens.
5. If you want to select additional optional information from a second table click the Choose Additional Information tab.
6. From the Choose Additional Information tab, select the appropriate type of additional information you want to include in the query.

   Note: You cannot remove a table from the query after you have selected it.

7. Click OK.

Published: May 17, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks