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 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 , Select All Diagrams button , and Clear Selection button work on the list of diagrams as a whole.
  • The Add Diagram To A New Map button , Update Diagrams button , Delete Diagrams button , Export Diagram Content button , and Change Diagram Owner button 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.

1. Click the SQL tab in the Filters section of the Find Diagrams pane.
2. Click New expression 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.

      

   2. Click Verify the SQL expression is valid .
   3. To combine that clause with another one, click 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 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):

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 , updated , exported , deleted , or transferred to another owner using the commands at the bottom of the pane.

The Delete Diagram button , Update Diagram button , and Change Diagram Owner button 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 and Add To a New Diagram Map button are unavailable when multiple diagram items are checked in the list.

Moreover, the Change Diagram Owner button 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 is unavailable in the Find Diagrams pane:

It becomes enabled after you select one or several diagram items in the list:

The Update Diagram button 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 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 —An empty cell when the diagram is consistent with respect to the last validated network topology space. It contains a yellow warning icon when the diagram may be inconsistent with respect to the network topology space.
• Type —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 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.

   

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.

   

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.