Adding an Advanced Query Group

Use Query Builder to create a group. Advanced queries allow you to set the conditions for the group. Each time you open the group, the query evaluates the database to determine which records to display. If you want to ensure the group does not change, create an ad hoc group instead.

To create an advanced query group

1. Open a list or detail view.
2. Click the Add Group button.
   The Infor CRM Query Builder opens.
3. Use the Conditions tab to define the conditional statement(s) used to select records.
4. If necessary, use the following Query Builder tabs:
   • Properties tab - Use to define the name and description of the group.
   • Layout tab – Use to define which data appears in the List view.

     The default layout is determined by the group you selected as the Default Group in your Group options.

   • Sorting tab – Use to define how the data is sorted.
5. When you finish making changes, click OK.

Related Topics

Example: Creating an Advanced Group

Groups Overview

Query Builder Overview

Modifying Groups