Example: Using the Query Builder to create a Group
The following example explains how to create a group of all primary contacts who work in the Sales department of their companies.
- Log on to application Web Client.
- Click Contacts on the Navigation Bar>
- Click Add Group from the Groups menu.
-
Complete this information on the Properties tab in Query Builder:
- In the Name field, specify Primary Sales Contacts.
- In the Description field, specify Primary contacts who work in Sales.
-
Complete this information on the Conditions tab:
- In the upper left side of the Query Builder, select CONTACT.
- In the upper right side of the Query Builder, double-click Isprimary.
- In the Operator field, select (=) equal to.
-
Next to the Value is field, click Browse, select
T (for True), and then click
OK.
Leave Case Sensitive Compare selected and do not select Use Value as a Literal.
- Click OK.
-
In the upper right side of the Query Builder,
double-click Department.
The Assign Condition window appears, with Department in the Field Name field, and String as the Field Type.
- In the Operator field, select contains.
- Next to the Value is field, click Browse, select Sales, and click OK.
- Clear the Case Sensitive Compare check box, and do not select Use Value as a Literal.
- Click OK.
-
Click the Layout tab. The Layout
tab displays which fields are displayed when the query is saved as a group.
Complete the following:
- On the right side of the Query Builder, select the Department field and double-click to add it to the grid below.
- Use the scroll bar to scroll to the far right, and click Department.
- Click Move Left repeatedly until Department appears between Account and City.
- Click the Sorting tab. By default, the contacts are sorted by last name in ascending (A-Z) order. If required, you can add additional sorting criteria or change the order.
- Leave the options set as it is the Defaults tab.
-
Click
OK.
The new Primary Sales Contacts group displays in the Contact Group list and you can select it to display all contacts that meet the criteria you defined.
Related topics