Skip to main content

 –

Extending the Interaction History table for the CaptureResponse service

Suggest edit Updated on September 21, 2021

Extend the Interaction History table to support custom properties for the CaptureResponse service.

  1. In Dev Studio, create the properties that you want to add in the appropriate interaction history class (Fact or Dimension).For example: Create an AccountID property in the Data-Decision-IH-Fact class.
  2. Create matching columns in the appropriate interaction table (Fact or Dimension).
    Note: If you use a database editor to add the columns, verify that they have been properly created.
    For example: Create an AccountID column in the pr_data_ih_fact table.
  3. Copy the Data-Decision-IH-Configuration.pyInteractionHistoryConfiguration data transform to your Artifacts ruleset and update it to add the new properties that you created in step 1.
  4. Click DecisioningDecisionsProposition ManagementHierarchy.
  5. Create the matching properties, for example, AccountID.
    Note: By default, this creates columns with a length of 32 characters. If required, edit the property and set the Max Length to a higher value.
  6. Copy the Data-Decision-IH-Configuration.MKTInteractionHistoryExtension data transform to your Artifacts rule set and update it to add the new properties that you created in step 1.
    Tip: Follow the pattern documented in the Comment field.
  7. Re-save the corresponding Database Table rule for the interaction class where you added the properties.For example: Re-save the Data-Decision-IH-Fact database table.
Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us