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 a single parameter on the Query Builder tab

1. Open the Query Editor as described in To open the Query Editor.
2. On the Query Builder tab, select a field from the drop-down list in the Field cell.
3. Select an operator from the Operator cell drop-down list.
4. Enter a value in the Value cell, or click the [...] button.

   The [...] button returns a list of all values for the specified field from the database table, allowing you to select the value you want. After selecting a value, click OK.

5. If you want to save the query in the current drawing for future use, click Store.
6. Click Execute to execute the query and close the dialog box.