Setup Dynamic Tables to Add P&ID Data from Multiple Drawings

The following setup procedures are in addition to the configuration required in the AVEVA P&ID Administration Program. Refer to Dynamic Tables Configuration Category.

1. Launch the SQL Server Management Studio application.

2. Navigate to PIDReports_projectName (for example, PIDReports_IPE).

3. Expand the Tables node and select the EQUList table.

4. Right-click and select Select Top 1000 Rows from the menu.

   

   Modify the query in the following way:

   • Remove TOP (1000) from the query.

   • Remove any columns which represent the drawing ID from the query. For example, [DRG+SHT], [Drawing No], [Sheet No] or [DrawingID].

     Provide alias names for these columns if they are to be part of the query. For example, modify [DRG+SHT] to as [DrawingName].

     Note: Do not remove the ID column, use the Order By ID DESC column to position the recently added item at the top of the dynamic table.

     In the example query, removed text is underlined and added text is bold.

     /****** Script for SelectTopNRows command from SSMS ******/

     SELECT TOP (1000) [ID]

     ,[Handle]

     ,[Owner Handle]

     ,[Block]

     ,[Func]

     ,[Prefix]

     ,[Tag]

     ,[Loop]

     ,[Suffix]

     ,[Description]

     ,[VPE P&ID Type]

     ,[Grid]

     ,[Interlocks]

     ,[Drawing No]

     ,[Sheet No]

     ,[Equipment Label]

     ,[DRG+SHT] as [DrawingName]

     ,[Project No]

     ,[Typical Item]

     ,[Symbol Name]

     ,[RecordStatus]

     ,[Object Revision]

     ,[Last update]

     ,[ExcelReport]

     ,[Item Type]

     ,[Item SubType]

     ,[Area Code]

     ,[Symbol Description]

     ,[ToUpdate]

     ,[UpdatePid]

     ,[DataSource]

     ,[Refrence Key]

     ,[SourcePrimary Key]

     ,[Major Revision]

     ,[Minor Revision]

     ,[Issued Status]

     ,[Revision Comment]

     ,[Issued Date]

     ,[CLASSNAME]

     ,[TAGFORMAT]

     ,[AREAPATH]

     ,[RefObjectYN]

     ,[RefObjectDrawingId]

     ,[RefObjectParentId]

     ,[Process Owner]

     ,[URICLASSNAME]

     ,[Pressure]

     ,[Temperature]

     ,[test]

     ,[Handle1]

     ,[DrawingID1]

     ,[EQUIPMENT_TAG-NUMBER]

     ,[EQUIPMENT_TAG-TRAIN]

     ,[EQUIPMENT_TAG-TRAIN_NUMBER]

     ,[GENERAL-DESCRIPTION]

     ,[PREFIX-DESCRIPTION]

     FROM [PidReports_IPE].[dbo].[EQULIST] order by [ID] DESC

5. Launch the AVEVA P&ID Reports application.

6. Navigate to the Customised Report tab and select an existing report.

7. Right-click and select Add from the menu to create a new customised report.

   

8. Enter a report name starting with TABLE_ (for example, TABLE_EQUNEWQUERY).

9. Copy the query from the SQL Server Management Studio application and paste into the query editor field.

10. Click Save.

    Note: To filter records based on drawing ID, add a where condition to the query with the drawing ID.