Secure Query: Selecting fields

Use the Select Fields tab 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.

1. On the Select Fields  tab, click the Select Fields button.

2. In the Select Fields to Show in Query window, select the fields you want to include in the query from the Fields to pick from list. Either double-click the fields or press the Shift and Ctrl keys as you select the fields and click Select. The selected fields appear in the Fields to include in query list on the right in the order you selected them; this is the order that the fields will display in your query. (To remove a field from the Fields to include in query list, highlight it and click Remove or double-click it.)

   Note: The available fields depend on the tables you selected in the Select Data To Use in Query window.

3. If needed, change the order of the fields by moving your cursor over the button to the left of the field until you see a two-headed arrow. Then press your left mouse button and drag the field to the new position. When you release the mouse button, the field moves to the new position and the other fields automatically reorder to accommodate the moved field.

4. After you select the appropriate fields, click OK.

   The Query main page opens.

To include additional data:

1. On the Select Fields tab, click Additional Data.

2. In the Select Data To Use in Query window on the Choose Employee Information tab, select the type of information 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 HR, Time Off, or Training.

3. If you want all the fields from the Master Table available to choose from:

   1. Click the Advanced button.
   2. In the Advanced Field Options window, select Make all Employee Master Table fields available for this query.

   3. Click OK.

4. In the Select Data To Use in Query window, if you want to select additional optional information from a second table:

   1. Click the Choose Additional Information tab.

   2. 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.

   3. Click OK.