Editable Grid from CDT

Question

Hi, 
 
 I'm trying to create an editable grid from a CDT whose values are set in a process model script node. 
 The following is the CDT where newPriority is the only editable field in the grid. All the fields have multiple values for all documents which are set in the process model.

Any way to implement this? 
 
 TIA :)

ekanshj · Answer

Hi, Please find the below code snippet for the requirement. load(
 local!x: {{
 docId:95351,
 docDes:"as",
 docName:"A",
 existingPriority:"1",
 newPriority: null
 },
{
 docId:"123",
 docDes:"AD",
 docName:"B",
 existingPriority:"2",
 newPriority: null
 }},
 a!gridLayout(
 label: "Test",
 headerCells: {
 a!gridLayoutHeaderCell(label: "Doc"),
 a!gridLayoutHeaderCell(label: "Desc", align: "RIGHT"),
 a!gridLayoutHeaderCell(label: "Name", align: "RIGHT"),
 a!gridLayoutHeaderCell(label: "Existing Priority", align: "RIGHT"),
 a!gridLayoutHeaderCell(label: "New Priority", align: "RIGHT")
 },
 rows: a!forEach(
 items: local!x,
 expression: a!gridRowLayout(
 contents: {
 a!imageField(
 images: a!documentImage(document:fv!item.docId ) ,
 readOnly: true
 ),
 a!textField(
 value: fv!item.docDes,
 readOnly: true,
 align: "RIGHT"
 ),
 a!textField(
 value: fv!item.docName,
 readOnly: true,
 align: "RIGHT"
 ),
 a!textField(
 value: fv!item.existingPriority,
 readOnly: true,
 align: "RIGHT"
 ),
 a!textField(
 value: fv!item.newPriority,
 saveInto: fv!item.newPriority,
 align: "RIGHT"
 )
 }
 ) 
 ),
 rowHeader: 1
 ) 
)

ManuelHTG · Answer

Best for me is always to use a Interface pattern from the Appian documentation. It comes with a load variable and the data already define inside. Then, I would declare my variable as a constant, check that it works with my data types. Finally I would call a query rule to get my data from the DB and replace the fields from my self-made variable. 
 
here the example from the documentation: 
 docs.appian.com/.../recipe_add_edit_and_remove_data_in_an_inline_editable_grid.html