Grid Options
- Last UpdatedAug 29, 2022
- 5 minute read
The grid has a configuration menu accessed via a right-click on any column title, and a context menu accessed via a right-click in any row.

Column Setup
Column Setup allows you to choose which columns to display in the grid view and which order to display them. To display the Column Setup window, right-click on any column title and select Column Setup from the pop-up menu. The Column Setup window contains the standard columns for the grid along with the attribute columns for the source type.

To display a Column Name in the grid view, select the required checkbox in the Visible column. Clearing a checkbox removes the Column Name from the grid view.
To change the position of a Column Name in the grid view, select the Column Name and click either the up or down arrows.
Click OK to update the grid view.
Note:
Grid layouts are automatically saved in the folder.
C:\Documents and Settings\<Current User>\LocalSettings\Application Data\Aveva\PDMS\SchematicInstrumentationAddin
With filenames like 'SchAiInstruments.xml' or 'SchAiLoops.xml'.
Settings
Right-clicking on any column title and selecting Settings, displays a settings sub-menu:
-
Enable Filtering
-
Enable Column Summaries
-
Enable Column Sort
-
Feedback Colors
Enable Filtering allows you to display a filter row in the grid view. The filter row is used to filter the grid to show only certain records. Instant "on the fly" filtering is achieved by selecting the icon in the column field and selecting a value from the drop-down list.

Further filtering is available by selecting the small icon to the left of a column (field) caption, selecting from the drop-down list and entering a value into the highlighted field. The grid view will automatically refresh to reflect the selected criteria.

Enable Column Summaries displays the
icon in the No of Changes column. Clicking the icon displays the Select Summaries window.

You can check one or all the boxes and click OK to receive a count displayed at the end of the No of Changes column.

Note:
Clicking Refresh removes the count.
Enable Column Sort allows you to change the column order. Click and hold on the column title and drag the column either left or right into a new position. Two arrows are displayed to assist you in positioning the column.

Clicking Feedback Colors displays a sub-menu:

Note:
New Element Row Color is used when an element is not matched and Compare/Update is able to insert it. The
Not Matched Row Color is used when an element is not matched and Compare/Update is not able to insert it.
Note:
Child Row Deleted Indicator Color is used if child rows contain both differences and logically deleted objects.
Clicking any of the options displays a Color Selection window.

Selecting Reset Default Feedback Row Colors, reverts the options back to their default color settings.
|
New Element Row Color |
Salmon |
|
Candidate for Deletion Color |
Orange |
|
Child Row Difference Indicator Color |
Brown |
|
Not Matched Row Color |
Grey |
|
Matched With No Changes Row Color |
White |
|
Matched With Changes Row Color |
Pale Yellow |
|
Linked With No Changes Row Color |
White |
|
Linked With Changes Row Color |
Pale Yellow |
|
Update Fail Row Color |
Red |
|
Child Row Deleted Indicator Color |
Salmon |
Export to Excel
The current grid layout and contents can be saved to an Excel file. Right-click in any column title and select Export to Excel, then enter a file name in the file browser window.
Print Preview
You can view a print preview of the current grid layout and content. Right-click in any column title and select Print Preview.
Grid Context Menu
Instrument datasheets and details can be displayed when the target is the schematic Database (DB) and the source is AVEVA Instrumentation. Right-click in any row in the Instruments or Loops grid view to display a context menu.
The Instruments grid view displays the following options:
-
Instrument Datasheet displays the AVEVA Instrumentation data sheet for the selected instrument.
-
Instrument Details displays the AVEVA Instrumentation window for the selected instrument.
The Loops grid view has one option:
-
Loop Details displays the AVEVA Instrumentation window for the selection loop.
Note:
No context menu exists for the Attribute Details tab.

The diagram view can be displayed when the source is Schematics DB, the selected source item appears on a diagram, and the SVG file is available for that diagram. Right-click in any row in the Elements grid view to display a context menu. Show in Diagram displays the diagram view for the selected source object.
