Update PivotDatabase records

Configure an integration item's Parameters properties accordingly to update the records in AVEVA™ Production Management.

To update the PivotDatabase record

1. Change the AllowModifyExistingRecords property to True.

2. Configure the FilterFields property. This enables you to specify the primary key fields in the AVEVA Production Management reporting point.

   • The primary key for a reporting point is not enforced, but the project design means that it is. This key could be a single field, such as SampleId, or multiple fields, for example, Material and Lot.

   • If multiple records match the key, they are updated.

     Note: Set the Filterable property for the fields to True.

Related topics

• PivotDatabase integration

• Finalize the processing of the integration

• Integration Diagnostics web server