Convert a QBE to an Advanced Condition

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

To convert a QBE to an advanced condition:

1. Open a QBE form by either starting a new QBE, opening the active QBE, or opening a saved QBE.
2. Verify the field values you specified in the tab pages in the QBE form.
3. Click Convert to Advanced Condition.

   The ACTIVE ADVANCED CONDITIONS EDITOR page appears.

   All the fields in which you specified values in the QBE form are listed as advanced condition attributes.

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.