how we can apply pagination on grid layout

Hi Lokesh,

AFAIK, We can't apply pagination on grid layout like grid field, but you can try having 2 buttons for back and forth and construct stored procedure with start index, batch size and on clicks you can send pagination to SP fetch the data.

Regards,
Swapna Chella

Hi Lokesh,

Grid Layout don't allow to add pagingInfo in it but there is a workaround for it.
You can user richtextfileds and dynamical links to achieve this.

Please go through below code, add this after your gridLayout Code.

a!richTextDisplayField(
value: {
a!richTextItem_18r1(
text: "<",
link: a!dynamicLink(
saveInto: {
a!save(
ri!pagingInfo.startIndex,
ri!pagingInfo.startIndex-ri!pagingInfo.batchSize)

}
),
showWhen: not(
ri!pagingInfo.startIndex <= 1
)
),
" ",
if(
ri!data.totalCount > 0,
{
ri!pagingInfo.startIndex,
" - "
},
""
),
if(
ri!pagingInfo.startIndex + ri!pagingInfo.batchSize - 1 > ri!data.totalCount,
ri!data.totalCount,
ri!pagingInfo.startIndex + ri!pagingInfo.batchSize - 1
),
if(
ri!data.totalCount > 0,
" of ",
""
),
ri!data.totalCount,
if(
ri!data.totalCount > 0,
" items ",
""
),
a!richTextItem_18r1(
text: ">",
link: a!dynamicLink(
saveInto: {
a!save(
ri!pagingInfo.startIndex,
ri!pagingInfo.startIndex + ri!pagingInfo.batchSize
)
}
),
showWhen: (
ri!data.totalCount >= ri!pagingInfo.startIndex + ri!pagingInfo.batchSize
)
)
},
align: "RIGHT"
)

Hi,

There is no option for pagination in Editable grid. As a work around You can try above mentioned approach as Swpanac said.
Or use following SAIL recipe which will do inline editing on a read only paging grid if inline editing of data is mandatory for your requirement.

forum.appian.com/.../SAIL_Recipes.html

Hi Lokesh,
Yes, We can apply pagination in paging grid layout and we can't apply pagination on editable grid layout. might be helpful below link ....

docs.appian.com/.../Paging_Grid_Component.html
docs.appian.com/.../Editable_Grid_Component.html

Hi Lokesh,

As others suggested. There is no pagination available for grid layout. We had this requirement for one of our customer long back so we have manually implemented the pagination for grid layout using buttons.

the logic works fine in normal scenario, but there is one problem, here, once you want to add a new dynamic row, then it fails as we are adding the new row data to the data-subset and data-subset is defined in with() (to refresh the data on change of pagination), so it fails as variable under with() cant be saved.

Hi Lokesh,

You should append the data on your actual variable (ri) not in datasubset

todatasubset(ri!Alldata,local!pagingInfo),

on the Add Link : append(ri!Alldata,save!value)

Thanks

Vinay Kumar Rai- i am doing the same, i am appending the values, but this all needs to performed under saveInto , so that's the real problem, and we are using dynamic link to perform add new row, as per appian sample example.

Lokesh, please share you code

Would it be possible to put the data into a local variable then have the link append onto that in the event something was added? I believe this would work under within the context of a with.