There is a requirement where i have to insert nested CDT(one to many) data into table and then read in another process model.
Parent CDT : policyDetails
policynumber
customerId
actiontype
nomineeDetails
Child CDT= nomineeDetails
{
title: "Mr", forename: "abc", surname: "Test One", dateOfBirth: "01/01/2000", percentage: 80, relationship: "Brother", addressLine1: "Hall Road"
}
title: "Mr",forename: "xyz",surname: "Test two",dateOfBirth: "01/01/2006",percentage: 50,relationship: "sister",addressLine1: "aaaaa",
My Approach :
Do you guys feel that there should be better approach?
Discussion posts and replies are publicly visible
Appian recommends using nested relationships ONLY for one-to-one and many-to-one relationships. One-to-many and many-to-many relationships should be flat to avoid performance issues when querying data.