Custom Queries

Top Previous Next

SQL-versed users can extract any data directly from TO3000, Version 9.0 database with the help of custom queries. Information extracted with the help of queries can be exported in common file formats like XLS, CSV, HTML, PDF.

To access custom queries:

1. Click menu Settings > Advanced.

2. Click Custom Queries section.

Custom Queries section displays the list of available queries. Double–click any of the queries in the list to open this query Query Builder window for editing.

Exporting and printing query results

To export the data gathered by a certain query, select this query and click Export Data button. This will run currently selected query and prompt you to select the format of output file.

To print the resulting data of a query, select it and click Print Data button. This will open Print Preview window. Click Print button to sent the query results to chosen printer.

Loading and saving queries

Queries can be saved to and loaded from a special .pxq files.

To save query in a .pxq file, select it and click Save button. Enter name of the file and click Save button.

To load a query from a .pxq file, click Load button and use Open TO3000, Version 9.0 Query window to locate the required pxq file.