SQLWizard Building Queries

Use the Build your query section to specify the conditions that you want to use to select data from the Site database.

Building a Database Query

To build a natural language query:

1    By default, SQLWizard creates a SQL statement that selects data which matches all the conditions specified in the query. If you want to change the type of query, click all and choose a new Comparison Operator.

2    Click < Click here to add new condition >. SQLWizard creates a default query.

3    In the default query, click the Field Selector, and select the database field you want to search from the drop-down list.

4    Click the Condition Selector and select the test that you want to use to select data.

5    Click the Condition Value at the end of the condition, and enter the value you want to identify.

You can use the * and % characters as wildcards. For example, to select from all entries in the NODENAME field, type *; to select all PCs with names that start with J, type J%.

6    To add another condition repeat steps 2 through 5.

To temporarily remove a condition from the query, deselect the check box at the left of the line.

To delete a condition, click the Condition Identifier and choose Delete Current Row.

Related Topics

Customizing SQLWizard

Example Queries

Previewing Queries

Querying Client Property Data