Customize Data saved at P&ID Reports Database Tables after Synchronize Routine is Executed

The project administrator can setup AVEVA P&ID to execute post processing SQL scripts after a synchronization routine is completed.

To do this, the project administrator must create a customized SQL script to modify the outcome of the most recent synchronization. The customized SQL script must be saved and registered on the P&ID Customized Reports tab, located in the P&ID Reports Utility. Refer to Create Reports with User Defined Queries.

To execute the customized SQL script, the project administrator must create a user defined directive named USER_EXECUTE_SQL_AFTER_SYNCH on the Miscellaneous – Settings Sub-Category of the AVEVA P&ID Project Administration program. Refer to Miscellaneous Configuration Category.

The value CLEARWARNINGS is the name of the customized SQL script registered by the project administrator in the P&ID Reports Utility.

In the example, the project administrator has created a customized SQL script routine designed to delete warning records produced by the synchronize routine, keeping the size of a large project database to manageable levels.

DELETE FROM [PROJNO].[DBO].[ERRORSANDWARNINGS] WHERE [PROJNO].[DBO].[ERRORSANDWARNINGS].[ERRORTYPE] LIKE 'WARNING'

Note: [PROJNO] must be replaced with the name of the project database in the example script.