Update Database records

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

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

• Test a Database integration

• Update Database records

• Finalize the processing of the integration