Query Results

When you've defined the query conditions, click the Search Now button to run the query.

Note: Columns to view and sort orders can be edited dynamically and the search process re-executed.

Loading the table

If a query loads a large number of results into the results table, you can increase the speed of the output process by specifying an increment by which to load the data — for example, load data in increments of 100, 500, or 1000 rows. The default number of results to load is defined on the Menu Security tab on the User Preferences form. You can also specify a row to display data from.

Object Drill Down

The green arrow before each piece of data indicates you can drill down on the object to open the source transaction or masterfile. Double-click the arrow to run the drill down.

Export Feature

To export table data into Excel, click the Export button, next to the Search Now button on the main form. Alternatively, click the >> button exportfeaturebutton or right-click the Export button to view extended export options. Greentree Desktop opens an application using the option selected and populate it with the query results. You can also save the results to a file.

Note: The Report writer option opens the Report Designer Wizard, enabling the query to be converted into a standard Greentree Desktop report.

Exported data uses the query criteria, columns to view, and sort criteria. If data in the table is manipulated in any way before the export — for example, hiding columns, sorting - this is not represented in the export.

When data is exported, Greentree Desktop creates a read-only file in your temp directory, regardless of whether you ultimately save the exported data or not. You may need to clear this directory periodically if this feature is in use.