Creating a process to update custom attributes

In Workbench, create an application. For example RCACustomAttributes.

Add a new process. For example, StoreCustomAttributes.

Add a Set Value operation, name the operation GetCustomAttribute, and add the following mapping data:

• Location: /process_data/customAttr

• Expression:/process_data/listCustomAttributeTO[1]

Add a Set Value operation, name it SetReleaseValue, add the following mapping data:

• Location: /process_data/@release

• Expression: /process_data/customAttr/object/@attrValue

Add an Execute SQL Statement (JDBC service) operation. Complete the following steps to add the release value that was set to create a row in the table.

• For the Datasource name property, select the appropriate data source from the list.

• Click the ellipsis button beside the SQL Statement box.

• In the SQL Info Editor dialog box, in the SQL Statement box write, type update ReviewRelease SET release = ? where reviewID =? .

• Select the Use Parameterized Query check box.

• Add the following data sets:

  • Index: 1 Type:STRING Value: /process_data/@release

  • Index: 2 Type: STRING Value: /process_data/@reviewId

• Click OK to close the SQL Info Editor dialog box.

Save and deploy the application

In Livecycle Administration Console, navigate to Home > Services > Applications and Services > Service Management > and select the ReviewCommentingAndApprovalService.

Select Whether To Use Custom Processes To Store/update/search Custom Attributes. checkbox.

In the Process Which Stores Custom Attributes box, type RCACustomAttributes/ StoreCustomAttributes.

Save.