Editable Grid Pagination

Question

Hi All 
 How To Write Pagination In Editable Grid ?Some Example

sureshk · Answer

Hi, 
 Yes we can add pagination to Editable Grid using 'Configurable Paging Info', available in AppMarket ( https://community.appian.com/b/appmarket/posts/configurable-paging-info) . 
 Here is a sample code which i used 
 load(
 local!items: {
 { item: "Item 1", qty: 1, unitPrice: 10 },
 { item: "Item 2", qty: 2, unitPrice: 20 },
 { item: "Item 3", qty: 3, unitPrice: 30 },
 { item: "Item 4", qty: 4, unitPrice: 40 },
 { item: "Item 5", qty: 5, unitPrice: 50 },
 { item: "Item 6", qty: 6, unitPrice: 60 },
 { item: "Item 7", qty: 7, unitPrice: 70 },
 { item: "Item 8", qty: 8, unitPrice: 80 },
 { item: "Item 9", qty: 9, unitPrice: 90 },
 { item: "Item 10", qty: 10, unitPrice: 100 },
 { item: "Item 11", qty: 11, unitPrice: 110 },
 { item: "Item 12", qty: 12, unitPrice: 120 },
 { item: "Item 13", qty: 13, unitPrice: 130 },
 { item: "Item 14", qty: 14, unitPrice: 140 },
 { item: "Item 15", qty: 15, unitPrice: 150 }
 },
 local!editableGridPagingInfo: a!pagingInfo(startIndex: 1, batchSize: 5),
 a!sectionLayout(
 label: "test",
 contents: {
 a!gridLayout(
 label: "Grid Layout test",
 instructions: "This is a grid layout",
 headerCells: {
 a!gridLayoutHeaderCell(label: "Item"),
 a!gridLayoutHeaderCell(label: "Qty", align: "RIGHT"),
 a!gridLayoutHeaderCell(label: "Unit Price", align: "RIGHT"),
 a!gridLayoutHeaderCell(label: "Total", align: "RIGHT")
 },
 rows: {
 a!forEach(
 items: todatasubset(
 local!items,
 local!editableGridPagingInfo
 ),
 expression: {
 a!gridRowLayout(
 contents: {
 a!textField(
 value: fv!item.item,
 saveInto: fv!item.item
 ),
 a!integerField(
 value: fv!item.qty,
 saveInto: fv!item.qty,
 align: "RIGHT"
 ),
 a!floatingPointField(
 value: fv!item.unitPrice,
 saveInto: fv!item.unitPrice,
 align: "RIGHT"
 ),
 a!textField(
 value: dollar(
 tointeger(fv!item.qty) * todecimal(fv!item.unitPrice)
 ),
 readOnly: true,
 align: "RIGHT"
 )
 }
 )
 }
 )
 }
 ),
 rule!APN_configurablePagingInfo(
 pagingInfo: local!editableGridPagingInfo,
 totalCount: length(local!items),
 showWhen: true()
 )
 }
 )
)

Editable Grid Pagination

Top Replies