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.
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