RB User Guide > Tools > Query Maker > Creating custom reports

Setting multiple query conditions

RB9 only

If you need more targeted results than a single-condition query provides, you can set up multiple conditions in one query to find the exact results you want. Use parentheses to group conditions. For example, to find law firms in Texas or Louisiana, you can query: (State is equal to TX OR State is equal to LA) AND FirmType is equal to Law Firm.

Continued from Creating custom reports.

1. With the query you want to refine set up in Tools > Query Maker, click > Add New Condition.
2. In the AND/OR column, AND appears as the default:

• AND

  Select this operator to tell the database to retrieve only those records matching both/all of the specified conditions.

• OR

  Select this operator to tell the database to retrieve records matching either of the specified conditions.

3. Repeat step 2 to add additional query conditions.
4. To group conditions to give them priority in executing the query click in the ( column of the first of the priority conditions and selecting ( in the drop-down. Then click in the ) column of the last of the priority conditions and select ) in the drop-down.
5. Click Execute. RB9 returns the results of your query. To:
   • Export your report to Excel or a generic CSV (comma separated values) file, see Exporting & printing results.
   • Remove a condition, click the condition’s > Delete.
   • Save your query to re-use later, see Saving queries.

Reference

• Database
• SQL
• Operators

Step-by-step instructions

• Exporting & printing results
• Saving queries