Use the Query Builder

Up a level to ..

Use the Query Builder

 

Share Data Between Drawings and Applications > Access External Databases > Use Queries to Filter Database Information > 

Use the Query Builder

Expand All Expand all collapsed sections. Collapse All Collapse all expanded sections.

Concept

Procedure

Quick Reference

To construct a query with multiple parameters on the Query Builder tab

1. Enter the first parameter of your query as described in To construct a query with a single parameter on the Query Builder tab.
2. Select the appropriate And or Or operator from the Logical field.

   Clicking in the Logical field inserts an And operator. Clicking the cell again changes the value to Or.

3. Enter additional query parameters on subsequent rows of the Query grid.
4. Repeat step 2 for each additional parameter except the final query parameter.
5. Apply any parenthetical grouping, if appropriate. Click the cell to the left of the Field cell that begins the phrase that you want to group. A single left parenthesis is inserted. Click the cell to the right of the Value cell that ends the phrase that you want to group. A single right parenthesis is inserted.
6. If you want to save the query in the current drawing for future use, click Store.
7. Click Execute to execute the query and close the dialog box.