Customize the Data in the Current Engineering Data Editor View - Intergraph Smart P&ID - Help - Intergraph

Intergraph Smart P&ID Help

Language
English
Product
Intergraph Smart P&ID
Search by Category
Help
Smart P&ID Version
9 (2019)
Smart Engineering Manager Version
10 (2019)
SmartSketch Version
10.0(2018)

The software allows you to perform various actions in an open view. You can customize the grid view in the following ways:

Search the Grid

In the Search field, as you type, items that match the search criteria are highlighted in yellow in the grid. To clear your search, click the X on the right.

  • If none of the cells in a row contain the search string, that row is hidden from the view.

  • If none of the cells in the entire grid contain the search string, all the data rows are hidden and the Search field is displayed with a red border.

  • When pagination is invoked, you can apply the search to all pages or to the current page only. The search options work as follows with pagination:

    • Current Page ā€” Displays only the rows from the current page that have matching strings. If there are no matching strings on a particular page, all the rows on that page are displayed.

    • All Pages ā€” Displays the rows from all the pages that have matching strings. The rows are displayed in one or more pages corresponding to the total number of rows with matching strings and the number of rows per page that was set.

Group Columns in the Grid

To group your data by a specific attribute, drag the column header to the Grouping area where the following text appears: "Drag a column header and drop it here to group by that column." You can group more than one attribute, by dragging another column header to this Grouping area. The order in which you apply the grouping changes the order of the displayed results.

When pagination is invoked, grouping is applied to the current page only.

SHARED Tip In the Engineering Data Editor, if the Grouping area is not visible, select the Enable Grouping button on the EDE toolbar.

Freeze Columns

To freeze columns, hold the cursor between the leftmost column and the adjacent column until it changes to a double-headed arrow, and then drag the vertical bar to the end of the last column you want to freeze. To unfreeze columns, position the cursor on the bar and when it changes to a double-headed arrow, drag the bar back to the extreme left.

EDE Freeze Columns PID_PPE

Sort Items in the Grid

The first time you open a view, the results are displayed in an ascending order based on the Item Tag column. Select a column header to sort by the values in that header in ascending order. To change the sorting order to descending, select the column header again. A small arrow in the column header displays the sort order. Selecting the column header a third time removes the sorting (rows are sorted in ascending order by the Item Tag column values). Press and hold the SHIFT key and select columns to sort by more than one column. When sorting by multiple columns, the column headers display a small number beside the arrow to indicate the column sequence for sorting:

When sorting column values in ascending order, the sorting behavior depends on the type of data as follows:

  • For columns with units of measure, the values are sorted in order of SI value regardless of the units, for example: 3.5 mm, 3.0 cm, 2.000 in, 4.0 in. Where several identical SI values exist, sorting is as follows:

    • Identical values with the same units of measure, but with a different number of decimal places are sorted in ascending order according to the number of decimal places, for example: 2.0 in, 2.000 in.

    • Identical values with different formats based on the same type of units of measure are sorted in ascending alphabetical order of the units (with symbols preceding letters of the alphabet), for example: 3.0", 3.0 in or 5.0 mil, 5.0 mm.

  • Values for all other data types are sorted alphabetically.

  • Cells with NULL values are not sorted and always appear at the top of the grid.

  • Empty cells are sorted and appear at the top when sorting in ascending order and at the bottom when sorting in descending order.

  • When pagination is invoked, sorting applies to the entire data set.

Filter Items in the Grid

  1. To filter your data, select Filter in the column header.

  2. Use the Filter by Column Data dialog to apply the filter:

    • In the upper part of the dialog, select from the list of values listed in the column using the check boxes.

      • Type in the Search field to narrow the available selection if required.

      • Use the Select All check box to select or clear all the check boxes for the list of values.

      • The values in the list beside the check boxes show distinct strings only; therefore, if an identical string appears in more than one row in the grid, that string is shown only once in the list.

      • The list can contain up to 1000 distinct strings.

      • If a column includes empty values, a check box with the value [empty] appears in the list.

    • In the Show rows with value that section, select the required operator from the list, then type a value in the blank field, and if required, select And/Or. When filtering numerical data with units of measure, the filtered results are sorted in order of SI value regardless of the units.

  3. When you have finished adding criteria to your filter, click Filter to display the filtered results.

  • A filtered column is indicated by a solid Filter icon .

  • If filtering is already applied and a filtered value is changed to a new value outside the range defined by the filter, the row with the new value is immediately excluded from the grid display.

  • To remove the filter criteria for a specific column, select the Filter icon and in the dialog for filtering the column data, select Clear Filter.

  • When pagination is invoked, filter applies to the entire data set.