To Set Rules for Attribute Edition in the Spreadsheet Editor (PPRSpreadsheetAttributeValidation_ID)

An opening ID is an entry point used to customize business logic. To Set Rules for Attribute Edition in the Spreadsheet Editor specifies the opening ID run to authorize/prevent attributes modification in the spreadsheet editor. The attribute values are checked and the validation result messages are displayed.

Note: The validation result messages are also displayed and logged in the Report Manager.
Note: For more information about customization by business rules, see Installation and Setup: Customize: Behavior: Data Setup: Customization by Business Rules.

This page discusses:

See Also
To Propagate Attribute Edition Rules in the Spreadsheet Editor (PPRSpreadsheetAttributeValuePropagation_ID)

General Information

The table below provides you with information related to the definition of the opening ID.

Definition Description
PLM Opening ID PPRSpreadsheetAttributeValidation_ID
Customization Intent Validation
Execution Context Client

Input Objects

Input objects must be of the following types:

  • ThisObject: PPR Object
  • Parameters: Corresponds to the context object.

Context Object Parameters

Parameter Name Type Read or Write Comments
strAttributeValue String Read Attribute value to be checked
strAttributeID String Read Attribute value to be checked
ReturnMessage String Write This message displays if the modification is prevented

Sample

The following sample shows how to set rules for attribute modification in the spreadsheet editor.

In this sample, only the customized attribute PaintSpecification is checked. Attribute modification is only allowed when the attribute value is equal to White or Grey.