This command applies a user-defined query on a data table. Records in the table that pass the query can be reported or the associated entities can be highlighted in the drawing. The Query Using option sets the source of the data table to process as either GIS data attached to selected drawing entities or from the current Output MDB file.
The query is defined in the dialog shown here. To add a query, enter a new query name in the in the space underneath Current Query. If there is already a name there, just highlight and type over it with a new name, then hit Clear all to clear out existing query lines and get full access to all Table Names. (The Table Names will become unavailable while query lines appear—because conditional queries only apply to the current table.) The top portion of the dialog contains a list of the query parameters. To add a parameter, select a table name from the Table pop-up list. The available tables will either be all the tables found in the GIS links of the drawing or all the tables from the Output MDB file depending on the Query Using option. Once a parameter has been added for a table, all the other query parameters must come from the same table. Once the table is specified, the Field Name pop-up list contains all the available fields in the table. Choose a field from this list. Next choose the operator (=, >, etc.) from the operator list. The Value pop-up list contains all the different values for that field that are found in the current data set. You can either select one of these values or type in another value into this field. When all the parameter values are set, pick the Add Parameter button.
When all the parameters are defined for the query, you can save these settings by filling out a name Current Query field and then picking the Save Query button. This query can be recalled later by highlighting the query name and clicking the Load Query button.
Pick the Execute button to process the query. With the Generate Report option, the program will bring up the Report Formatter which allows you to choose the fields to include in the report and the report format. If the Highlight Screen Entities option is on, then the program will highlight the entities with GIS data that pass the query. Point entities are highlighted by drawing a box around the point and polylines are highlighted by solid fill. Shown here is the report for a query of cities with population greater than 10 million.
POPULATION NAME COUNTRY CAPITAL
23,620,000 Tokyo Japan Y
16,472,000 New York US N
15,850,000 Seoul Korea Rep Y
15,175,000 Sao Paulo Brazil N
15,040,000 Osaka Japan N
14,100,000 Mexico City Mexico Y
13,100,000 Moskva Russia Y
11,100,000 Calcutta India N
11,100,000 London UK Y
10,750,000 Buenos Aires Argentina Y
10,150,000 Rio de Janeiro Brazil N
Pulldown Menu Location: GIS Data
Keyboard Command: gis_query
Prerequisite: MDB file with data or entities with linked GIS
information
File Name: \lsp\gisview.arx