Create, load, and save a SQL query

To create and run a query using SQL commands, and optionally load and save SQL queries

  1. Launch the Query Builder.
  2. On the View menu, click SQL View. Open the View menu again and select Search Mode or Template Designer Mode.
  3. Enter SQL text representing the selection criteria and column definitions. There might already be SQL text, representing any search criteria set in the Simple View.
  4. Optionally, click Load (on the right side of the dialog box) to open a saved *.qry file from the network which will replace any text already in the SQL text window.
  5. Optionally, click Save (on the right side of the dialog box) to save just the SQL text as a *.qry file in a network location.
  6. Click OK to run the search. Any results will appear under the Search Results node.