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
Discussion posts and replies are publicly visible
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.