Search for network diagrams in the database

The Find Diagrams function identifies diagrams that contain specific features or objects or cover a given extent of the active map. It allows you to search for diagrams generated or updated on a specific date, created by a particular user, and so on. The diagrams associated with the search appear in a list where you can open, update, delete, or export them.

Note:

The workflows detailed below can be executed when working with either a utility network or trace network in a file geodatabase, a utility network service, or a database connection to the utility network in an enterprise geodatabase.

To search for network diagrams at a particular past moment, see Working with historical moments.

Open the Find Diagrams pane

You can use the Find Diagrams pane to search for diagrams. The sections below explain how to open this pane.

Find diagrams related to a part of the network

To search for diagrams that contain particular network features or objects or cover a given extent of the network in a map, follow these steps:

  1. Open the map view that references the related utility network or trace network layer.
  2. Select this layer in the Contents pane.

    The Utility Network or Trace Network contextual tab set becomes available.

  3. On the Data tab of the Utility Network or Trace Network tab set, in the Diagram group, click Find.

    The Find Diagrams pane appears.

Find diagrams referencing the same diagram features

To search for diagrams that contain the same network features or objects as those associated with the diagram features in the active diagram map, follow these steps:

  1. Activate your network diagram map view.
  2. In the Contents pane, select the network diagram layer.

    The Network Diagram contextual tab becomes available.

  3. In the Manage group on the Network Diagram tab, click Find.

    The Find Diagrams pane appears.

Get started with the Find Diagrams function

In both cases, the Find Diagrams pane appears and has two main sections: Diagrams and Filters.

The two sections of the Find Diagrams pane
  • The Diagrams section, number 1 above, lists the diagrams returned from the search.
  • At the bottom of this section is a row of buttons:
    • The Refresh button Refresh, Select All Diagrams button Select All Diagrams, and Clear Selection button Clear Selection work on the list of diagrams as a whole.
    • The Add Diagram To A New Map button Add To A New Diagram Map, Update Diagrams button Update Diagram, Delete Diagrams button Delete Diagrams, Export Diagram Content button Export Diagram Content, and Change Diagram Owner button Change Diagrams Owner work on selected items.
  • The Filters section, number 2 above, allows you to filter the diagrams returned in your trace results.

When the Find Diagrams pane appears, the default active tab in the Filters section is Basic.

When the Cover parts of the active map extent check box is checked, the search looks for diagrams that have extents intersecting the current map (a diagram map or a geographic map). This option is checked by default.

Find diagrams referencing features or objects in the active map

To find diagrams that reference features or objects in the active map, follow these steps:

  1. Click the Basic tab in the Find Diagrams pane.
  2. In the active map, do one of the following:
    • Adjust the map display to the extent you want.
    • Select the set of features or objects you want included in the diagrams.
  3. Choose one or both of the following:
    • Cover parts of the active map extent—Searches for diagrams with an extent that intersects the current extent of the active network map or the geographic extent of the active diagram map.
    • Contains selected features or objects in the active map—Searches for diagrams that contain any of the network features or network objects selected in the active network map or any network feature or network object associated with the diagram features selected in the active diagram map.
  4. Click Apply.

    The list in the Diagrams section is refreshed and displays all diagrams that satisfy the option or options you specified.

    Note:
    • The Contains selected features or objects in the active map option is available only when there are network elements or diagram features selected in the active map.
    • When the Contains selected features or objects in the active map option is checked, the search returns diagrams containing features or objects selected in the active map, regardless of whether those features or objects are visible or aggregated in the diagrams.
    • If both the Cover parts of the active map extent and Contains selected features or objects in the active map options are checked, the search returns diagrams that either cover parts of the active map extent or contain features or objects selected in the active map. Those selected features or objects may not be reflected in the current visible map extent.

Find diagrams using SQL expressions

To search diagrams using an SQL expression, use the SQL tab in the Filters section.

SQL tab with default content

  1. Click the SQL tab in the Filters section of the Find Diagrams pane.
  2. Click New expression New to begin building your query.
    1. Select a field, an operator, and value or field to evaluate against.

      For example, you can select the Last update field to search for diagrams that have not been updated for a week, a month, and so on.

      Add Clause

    2. Click Verify the SQL expression is valid Verify.
    3. To combine that clause with another one, click New Add Clause, select the exclusive (And) or additive (Or) operator, and set up the new clause.
    4. Click Apply when all clauses you want are set up.

      All the diagrams related to the utility network or trace network that verify the specified query display in the Diagrams section.

      Note:

      The SQL query fields allow you to filter diagrams by their name, the name of their template, their consistency state, the user who created or updated them, and the time the diagram was created or last updated.

Find Diagrams filtering logic

Use the following sections to work with the Find Diagrams pane:

Basic tab and SQL tab settings

When there are settings specified on both the Basic and SQL tabs, they are combined with an exclusive logic (And).

When there are no settings specified on the Basic and SQL tabs, clicking Apply displays all the diagrams stored in the database at the bottom of the Diagrams section.

Refine the diagrams returned from a search

Checking the Exclude the subnetwork system diagrams option prevents any system diagram from being retrieved.

Additionally, the list of diagrams found in a search can be dynamically refined by typing a keyword in the Search the list of diagrams to refine results text box.

The Search function in the Find Diagrams pane

The list is filtered on the fly and includes only diagrams with names containing the character, string, or keyword specified.

The following images show the diagram list filtered for diagrams with names that contain the letter m (left) and the string my (right):

Refining find diagrams list with a letterRefining find diagrams list with a string

Clear the Find Diagrams pane settings

To remove any specified settings in the Find Diagrams pane, follow these steps:

  1. Click the Basic tab , uncheck the Cover parts of the active map extent, Contains selected features or objects in the active map, and Exclude the subnetwork system diagrams check boxes, and click Apply.
  2. Click the SQL tab, click Clear Expression, and click Apply.

Use the Find Diagrams pane

You can complete several tasks using the Find Diagrams pane.

Open, update, convert, or export diagrams or change their ownership

Diagram items in the Diagrams section can be opened Add To A New Diagram Map, updated Update Diagram, exported Export Diagram Content, deleted Delete Diagrams, or transferred to another owner Change Diagrams Owner using the commands at the bottom of the pane.

Diagram commands on the Find Diagrams pane

The Delete Diagram button Delete Diagrams, Update Diagram button Update Diagram, and Change Diagram Owner button Change Diagrams Owner are enabled when you select one or several diagram items in the list since the related Delete Diagram, Update Diagram, and Change Diagrams Owner geoprocessing tools can run on multiple diagrams.

However, the Export Diagram Content button Export Diagram Content and Add To a New Diagram Map button Add To A New Diagram Map are unavailable when multiple diagram items are checked in the list.

Moreover, the Change Diagram Owner button Change Diagrams Owner is visible at the bottom of the Find Diagrams pane only when the following conditions are met:

  • The diagram layer or network layer datasource in the active map from which the Find Diagrams pane opens is from a utility network or trace network in a file geodatabase or a database connection to a utility network in an enterprise geodatabase.
  • When working with a utility network in an enterprise geodatabase, the user currently connected to the portal is the utility network owner.
The Change Diagram Owner button Change Diagrams Owner is unavailable in the Find Diagrams pane:
Change Diagrams Owner button in Find Diagrams pane disabled
It becomes enabled after you select one or several diagram items in the list:
Change Diagrams Owner button in Find Diagrams pane enabled

The Update Diagram button Update Diagram also responds to logical contexts; it is systematically unavailable when using a database connection or, for the case of a utility network, when there is a subnetwork system diagram selected among the checked diagram items. Such a diagram cannot be updated using the Update Diagram tool.

The Delete Diagram button Delete Diagrams is unavailable for these particular subnetwork system diagrams unless you are connected to the portal as the utility network owner.

Customize the display of items

Use the following sections to customize how items are displayed:

Predefined columns

The Diagrams section includes the following predefined columns that display field attributes for each detected diagram:

  • Name—The diagram name.
  • Consistency State Consistency State column—An empty cell when the diagram is consistent with respect to the last validated network topology space. It contains a yellow warning icon May be inconsistent when the diagram may be inconsistent with respect to the network topology space.
  • Type Black exclamation—The type of diagram. A cell contains a green exclamation mark to indicate a system diagram; that is, a diagram tied to a subnetwork that is entirely managed by the Update Subnetwork tool when it executes. A cell is empty when the diagram is a user-created diagram.
  • Template—The template name.
  • Tag—The diagram tags.

Note:

A diagram with an empty cell for the Consistency State column is consistent with respect to the last validated network topology space but may be inconsistent with respect to the network editing space; that is, it may reference features or objects that are currently impacted by a network dirty area. In this case, when the diagram is opened, a red error icon Dirty features is displayed.

Add or remove columns

To add or remove columns in the Diagrams section, follow these steps:

  1. Click a column header in the Diagrams section.
    A pop-up dialog box appears.
    Columns to allow sorting the diagram list
  2. Under Columns, double-click the column or columns you want to add (items checked) or remove (items unchecked) from the Diagrams section.
  3. Optionally, use the arrows on the right to reorder the display of columns in the Diagrams section.
  4. Click OK.

Sort the diagrams

By default, the diagrams in the Diagrams section are sorted alphabetically by name. You can also sort them by any other column value.

  1. Click the column header you want to sort on in the Diagrams section.
    A pop-up dialog box appears.
    Columns to allow sorting the diagram list
  2. On the pop-up dialog box, click Sort A to Z or Sort Z to A depending on the order you want to sort the diagram names.

Related topics