QueryFeature

The QueryFeature utility allows the user to select an icon that will bring up a query dialog. This dialog will allow the user to query certain features using a pre-defined set of filters. Before it can be used however, a script must be run on the database user that will create a table of QueryFeature definitions. Locate this script in the C:\Program Files\Bentley\ Communications CONNECT Edition\ OpenCommsDesigner\Database\Spatial folder. The filename is OpenCommsQueryFeatureDefs.sql.

This SQL has many sample features listed that some users may not want to have populated in their query box…for example there are many copper features and duct features listed. If the user does not use Copper or Duct, they would want to remove those features from the script. Just delete the entire line that begins with ‘insert into queryfeaturedef….’ For any feature not desired.

Note: This list of features is not a list of features you will want to query out in your work—you will always be able to query any or ALL features in the database for your work. This is a list of features you would want to initiate a query by…i.e. if you were in a blank map, but knew the name of a node that you knew was in the area you wanted to work, if Fiber Node Name is in your list, you could initate the query by that feature.

If the user desires to query by Optical System names (‘CIRCUIT NAME’ in the list of features), two lines near the bottom of the script will need to be edited with the XY extents of the project. Edit the bold areas with the MetaData extents of the geospatial project:

MDSYS.SDO_DIM_ELEMENT('X', 2953483.87466666, 3255747.33866664, 0.000000050),

MDSYS.SDO_DIM_ELEMENT('Y', 9959575.00000001, 10232167.0000018, 0.000000050)

If the user will not be querying by Optical System names, the following section can be deleted from the script:

******************************************************************************************

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)

VALUES ('QT_SPANSOPTSYS', 'OGC_GEOMETRY', MDSYS.SDO_DIM_ARRAY

(

MDSYS.SDO_DIM_ELEMENT('X', 2953483.87466666, 3255747.33866664, 0.000000050),

MDSYS.SDO_DIM_ELEMENT('Y', 9959575.00000001, 10232167.0000018, 0.000000050)

NULL);

*******************************************************************************************

After editing the OpenCommsQueryFeatureDefs.sql for only the desired features, paste it into SQL Developer and run it against the database user to add the desired Definitions to the new table.

On the Home tab of OpenComms Designer select the Query Feature icon in the Spatial Tools section:

The QueryFeature search dialog will display:

Clicking the dropdown will display all the features you added to the QueryFeatureDef table when you ran the script:

Enter valid data in the Value box for the Query criteria and click on the Query button:

This will display the Query Feature Results dialog:

Select Locate for the feature to activate the query from the database. When queried, the feature will be displayed in the active view.