Convert a Value Set to an Advanced Condition

You can use an existing filter value set to start to build an advanced condition that uses Boolean or set operations between elements that have multiple values. When you convert a value set to an advanced condition, all the fields in which you entered values are listed on the ACTIVE ADVANCED CONDITIONS EDITOR page as advanced condition attributes.

To convert a value set to an advanced condition:

1. Create a new value set by either using predefined filters or creating custom filters.

   Alternatively, from the FILTER LIBRARY page, open a saved value set (see Work with Saved Filters and Value Sets).

2. Verify the field values specified in the fields in the value set.
3. Click Convert to Advanced Condition.

   The ACTIVE ADVANCED CONDITIONS EDITOR page appears.

   All the fields in which the values were specified are listed as advanced condition attributes. The fields with multiple values are repeated.

4. Build your query further by:
   • Adding additional attributes (fields) and specifying their values
   • Adding another advanced condition as an attribute
   • Placing runtime parameters in attributes
   • Placing parentheses to determine the query execution order
   • Specifying conditions for attributes values
   • Specifying Boolean and set operators to join the attributes

See Use Advanced Conditions to Create Queries on Insight Mart for detailed information about using the Advanced Conditions Editor.