Replacing hard coded data in a editable grid

Question

Hi 
 Have been playing around with the editable grid used in: 
 https://docs.appian.com/suite/help/19.2/recipe-add-edit-and-remove-data-in-an-inline-editable-grid.html 
 I've a CDT called Employee with the same structure, and have created a constant for it, and also the following expression rule (called "EmployeeData") to return the data: 
 a!queryEntity( entity: cons!EMPLOYEE_DSE, query: a!query( selection: a!querySelection( columns: { a!queryColumn(field: "id"), a!queryColumn(field: "firstName"), a!queryColumn(field: "lastName"), a!queryColumn(field: "department"), a!queryColumn(field: "title"), a!queryColumn(field: "phoneNumber"), a!queryColumn(field: "startDate"), } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ) ) 
 Am struggling to replace the hard coded data in the editable grid code, with the CDT though. What do I need to put it in to replace the { hard coded data}? 
 
 Many thanks 
 David

shubham.aware · Answer

If you have data in employee table map that to local!employee if want based on requirement change the header cell 
 a!formLayout ( 
 label: "Example: Add,Update, or Remove Employee Data" , 
 contents: { 
 a!gridLayout ( 
 totalCount: count ( local!employees ), 
 headerCells: { 
 a!gridLayoutHeaderCell ( label: "First Name" ), 
 a!gridLayoutHeaderCell ( label: "Last Name" ), 
 a!gridLayoutHeaderCell ( label: "Department" ), 
 a!gridLayoutHeaderCell ( label: "Title" ), 
 a!gridLayoutHeaderCell ( label: "Phone Number" ), 
 a!gridLayoutHeaderCell ( label: "Start Date" , align: "RIGHT" ), 
 /* For the "Remove" column */ 
 a!gridLayoutHeaderCell ( label: "" ) 
 }, 
 /* Only needed when some columns need to be narrow */ 
 columnConfigs: { 
 a!gridLayoutColumnConfig ( width: "DISTRIBUTE" , weight: 3 ), 
 a!gridLayoutColumnConfig ( width: "DISTRIBUTE" , weight: 3 ), 
 a!gridLayoutColumnConfig ( width: "DISTRIBUTE" , weight: 3 ), 
 a!gridLayoutColumnConfig ( width: "DISTRIBUTE" , weight: 3 ), 
 a!gridLayoutColumnConfig ( width: "DISTRIBUTE" , weight: 3 ), 
 a!gridLayoutColumnConfig ( width: "DISTRIBUTE" , weight: 2 ), 
 a!gridLayoutColumnConfig ( width: "ICON" ) 
 }, 
 /*
 * a!forEach() will take local!employee data and used that data to loop through an
 * expression that creates each row.
 *
 * When modifying the recipe to work with your data, you only need to change:
 * 1.) the number of fields in each row
 * 2.) the types of fields for each column (i.e. a!textField() for text data elements)
 * 3.) the fv!item elements. For example fv!item.firstName would change to fv!item.yourdata
 */ 
 rows: a!forEach ( 
 items: local!employees , 
 expression: a!gridRowLayout ( 
 contents: { 
 /* For the First Name Column*/ 
 a!textField ( 
 /* Labels are not visible in grid cells but are necessary to meet accessibility requirements */ 
 label: "first name " & fv!index , 
 value: fv!item.firstName , 
 saveInto: fv!item.firstName , 
 required: true 
 ), 
 /* For the Last Name Column*/ 
 a!textField ( 
 label: "last name " & fv!index , 
 value: fv!item.lastName , 
 saveInto: fv!item.lastName , 
 required: true 
 ), 
 /* For the Department Column*/ 
 a!dropdownField ( 
 label: "department " & fv!index , 
 placeholderLabel: "-- Select -- " , 
 choiceLabels: { "Corporate" , "Engineering" , "Finance" , "Human Resources" , "Professional Services" , "Sales" }, 
 choiceValues: { "Corporate" , "Engineering" , "Finance" , "Human Resources" , "Professional Services" , "Sales" }, 
 value: fv!item.department , 
 saveInto: fv!item.department , 
 required: true 
 ), 
 /* For the Title Column*/ 
 a!textField ( 
 label: "title " & fv!index , 
 value: fv!item.title , 
 saveInto: fv!item.title , 
 required: true 
 ), 
 /* For the Phone Number Column*/ 
 a!textField ( 
 label: "phone number " & fv!index , 
 placeholder: "555-456-7890" , 
 value: fv!item.phoneNumber , 
 saveInto: fv!item.phoneNumber 
 ), 
 /* For the Start Date Column*/ 
 a!dateField ( 
 label: "start date " & fv!index , 
 value: fv!item.startDate , 
 saveInto: fv!item.startDate , 
 required: true , 
 align: "RIGHT" 
 ), 
 /* For the Removal Column*/ 
 a!imageField ( 
 label: "delete " & fv!index , 
 images: a!documentImage ( 
 document: a!iconIndicator ( "REMOVE" ), 
 altText: "Remove Employee" , 
 caption: "Remove " & fv!item.firstName & " " & fv!item.lastName , 
 link: a!dynamicLink ( 
 value: fv!index , 
 saveInto: { 
 a!save ( local!employees , remove ( local!employees , save!value )) 
 } 
 ) 
 ), 
 size: "ICON" 
 ) 
 }, 
 id: fv!index 
 ) 
 ), 
 addRowlink: a!dynamicLink ( 
 label: "Add Employee" , 
 /*
 * For your use case, set the value to a blank instance of your CDT using
 * the type constructor, e.g. type!Employee(). Only specify the field
 * if you want to give it a default value e.g. startDate: today()+1.
 */ 
 value: { 
 startDate: today () + 1 
 }, 
 saveInto: { 
 a!save ( local!employees , append ( local!employees , save!value )) 
 } 
 ), 
 rowHeader: 1 
 ) 
 }, 
 buttons: a!buttonLayout ( 
 primaryButtons: a!buttonWidget ( 
 label: "Submit" , 
 submit: true 
 ) 
 ) 
 ) 
 )

Mike Schmitt · Answer

You should store the result of your query in a load() variable (assuming you're not on 19.2 yet). Your editable grid can directly reference the CDT data stored in the local variable. If you've already tried this and still having trouble with it, please post the full current version of your interface code since we can't tell what the issue is without more detail. If you do, please use the "Insert -> Code" functionality to put it in a clean code box which preserves formatting as well as prevents the comment box from getting unreasonably long.