Queries

SQL-versed users can extract any data directly from the TO3000 3D 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. Go to Backstage > Advanced Settings.

2. Click the Queries section.

The Queries section displays the list of available queries. Double–click any of the queries in the list to open this query in the 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 the currently selected query and prompt you to select the format of the output file.

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

Loading and saving queries

Queries can be saved to and loaded from special .px15 files.

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

To load a query from a .px15 file, click the Load button and use the Open TO3000 3D+ Query window to locate the required px15 file.