TRAX MANUALS > TRAX Quick Print > TRAX Quick Print Module > Quick Print Menu > Quick Print Buttons > Sub Query Button

Sub Query Button

The Sub Query function is used to query for detailed information. In the following example the user will create a sub query for the last order created for a certain part.

1. From the Update window, open a table.
2. In the lower half of the window, specify a column, operator and value.
3. Enter a title for the print.
4. Select the Sub Query button.

TRAX displays the Sub Query window.

1. Enter a name for the table.
2. Open a table and select desired fields.
3. In the lower half of the window, select the Order By tab.

   The options will appear on the left side of the pane.

   Select the criteria to appear in the sub query, (ie. "ORDER_DETAIL"."CREATED_DATE"). To do this, simply drag the selection from the left side of the window to the right side of the window.

4. Select the 'D' for descending. In this example, the user is querying for the last order created for a certain part, therefore 'Descending' is selected.
5. Select the Save button.

The sub query created now appears in the Update window. The user may delete the table titled "ORDER_DETAIL."

1. Right click in the Column section of the window and select 'Delete Clause' from the drop down selection.
2. In the table, select the fields to be included in the sub query preview.
3. Select the Preview button.

The preview appears as shown below including all criteria selected in the above screen.

Return to the Query window by selecting the Query button.