Add multiple values to the interface and store them in DB

Question

Hi Community Team, 
 I'm facing issue to store multiple values in Database, My task is to accomplish to add multiple comments in a interface section layout. I need to store them by saving them into Cdt. 
 User Scenario: For each comment it needs to generate new Primary Key. . Data need to be entered in a new row for each comment.

Comments

Comment1 
 Remove Icon

Comment2 
 Remove Icon

comment 3 
 Remove Icon

Add Icon to add new comment

Sanchit Gupta (Xebia) · Accepted Answer

Assuming ri!mention is of Comment CDT type. Your code should look like this: 
 a!gridLayout(
 label: "Add Comments",
 emptyGridMessage: "No Comments Added",
 headerCells: {
 a!gridLayoutHeaderCell(label: "Comments"),
 a!gridLayoutHeaderCell(label: "")
 },
 columnConfigs: {
 a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
 a!gridLayoutColumnConfig(width: "ICON")
 },
 rows: a!forEach(
 items: ri!mention,
 expression: a!gridRowLayout(
 id: fv!index,
 contents: {
 a!textField(
 label: "No" & fv!index,
 labelPosition: "ABOVE",
 value: fv!item.mention,
 saveInto: fv!item.mention,
 validations: {},
 align: "CENTER"
 ),
 a!imageField(
 label: "delete " & fv!index,
 images: a!documentImage(
 document: a!iconIndicator("REMOVE"),
 altText: "Comment " & fv!index,
 caption: "Comment " & fv!index,
 link: a!dynamicLink(
 saveInto: a!save(ri!mention, remove(ri!mention, fv!index))
 )
 ),
 size: "ICON"
 )
 }
 )
 ),
 addRowlink: a!dynamicLink(
 label: "Add new comment",
 saveInto: {
 a!save(
 ri!mention,
 append(ri!mention, type!CommentCDT)
 )
 }
 )
)

Sanchit Gupta (Xebia) · Answer

You need to set the requestId in your comment CDT, you can do that in the process or I would suggest changing the save in addRowLink like: 
 a!save(
 ri!mention,
 append(
 ri!mention,
 type!CommentCDT(
 requestId: ri!requestId/*ri! or localVariable in which you are having requestId*/
 
 )
 )
) 
 If you are writing to the request table after form submission then update the value in requestId of Comment Cdt with the generated primary key of Request table. 
 And for writing multiple entries make sure that the node input for the entity in WDSE is of multiple type.

Sanchit Gupta (Xebia) · Answer

Unknown said: If you are writing to the request table after form submission then update the value in requestId of Comment Cdt with the generated primary key of Request table. 
 This is exactly what I meant when I said this.

Chandrasekhar Reddy · Answer

We can achieve it by without passing the parameters into the cdt.. Need to configure output of Script task of Process Model. 
 The code here it works me in interface is: addRowlink: a!dynamicLink(
 label: "Add new comment",
 saveInto: {
 a!save(
 ri!mention,
 append(
 ri!mention,
 'type!{urn:com:appian:types:CT}CT_Comments_ID'()
 
 /* rule input, type!cdt Name */
 )
 )
 }
 )

Add multiple values to the interface and store them in DB

Top Replies