Enter Database Query

Use the SQL query tab of the Enter Database Query dialog to specify criteria that Vector AM can use to select the members of this group, then select the Preview tab to check the results of the query.

To create a Client selection query:

1    Type a SELECT statement that identifies the Clients you want to include in the group.

2    When you have specified all the Client selection conditions for the group, select the Preview tab to list the Clients that will be returned by your query.

3    Click Next to continue.

Notes

To enter a database query using natural language, click Back to return to the Group Properties dialog, and choose Select clients using natural language.

Related topics

Combining Data from Multiple Tables

Example Filter Expressions

Logical and Compound Operators

Using Client Properties in Filter Expressions

Using Dates in Filter Expressions