Integrate a QBE with an Advanced Condition

You can integrate a new, active, or saved QBE with an existing advanced condition through these set operators:

• INTERSECT
• MINUS
• UNION

If required, you can integrate your QBE with multiple advanced conditions that can have Boolean or set operations between them.

To integrate a QBE with existing advanced conditions:

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 the Advanced Conditions tab.
4. In the Operator field, select a set operator to integrate the QBE and the advanced condition.
   You may select INTERSECT, MINUS, or UNION.
5. Select the advanced condition to integrate with the QBE as follows:
   1. Click the Add Advanced Condition Above icon on the left bar to open the Advanced Conditions menu.

      This menu lists all the advanced conditions (based on Insight Mart only) that are stored in the system and accessible to you. The conditions are organized by categories.

      
   2. Browse to the appropriate category, and select the required advanced condition.
      The selected row is added in the Advanced Conditions Editor.
   3. Click the Add Advanced Condition Above icon, or the Add Advanced Condition Below icon to insert another advanced condition above or below the existing advanced condition.

      Tip:

      To change the structure of the query by changing the order of the rows, select a row and then click the arrow icons to move the row up or down.
6. Enter parentheses in the ( and ) columns to determine the order of execution for the selected advanced conditions.
7. In the Operator column, specify the set operation to perform between the selected advanced conditions.
8. Click Save As to save your integrated query.
   • To run the integrated QBE and generate the case series, click Execute.

     The ACTIVE CASE SERIES page appears with the case series.

     See Work with Case Series for more information.

   • To convert the integrated QBE and advanced condition into a single advanced condition, click Convert to Advanced Condition.

     See Convert a QBE to an Advanced Condition for more information.

For detailed information about using the Advanced Conditions Editor, see Use Advanced Conditions to Create Queries on Insight Mart.