pagination in Editable Grid

Hi,

See the related post here https://community.appian.com/discussions/f/new-to-appian/24424/pagination-in-editable-grid

As Naresh suggested already, this has been discussed many times in the past in previous posts here in Community, usually under the subject heading of "sorting" editable grids (for our purpses, sorting and pagination should be treated as essentially the same subject since they both involve the same principles and the same underlying functionality).

That being said, I just tried searching for past posts on the subject and I find that searching old posts seems to be broken at the moment.  I think someone may have mentioned this to me last week but I'd forgotten.  [mention:a2a993efb6cb41e7b76d6c157987a394:e9ed411860ed4f2ba0265705b8793d05] / [mention:115d03e07c2843c691ef69b0951c7286:e9ed411860ed4f2ba0265705b8793d05] is this a known issue? (Sorry to keep bugging you two this morning).

Back to the subject at hand, though - as in the past, I strongly recommend against rushing into implementation of some bespoke editable-grid-pagination scheme, especially since it requires manual implemention and some pretty serious work-arounds to avoid overwriting already-changed data. It's doable but in my estimation, anyone familiar enough with manual SAIL development to do this safely, will also be familiar enough with it to do the implementation pretty much on their own.  This isn't meant as some sort of "gatekeeping", but more as an advisory of how difficult it can be (i usually don't even try to do it myself).  I usually suggest, instead, to have a read-only grid (with inherent paging) where a user can click some sort of "edit" link on an individual row, make and save changes to that row, then continue with other rows if they want.

with(
local!maxStartIndex: 1 + rounddown(
(
ri!totalCount - 1
) / ri!pagingInfo.batchSize,
0
) * ri!pagingInfo.batchSize,
local!style: "STRONG",
if(
rule!replaceNull(
ri!showWhen,
true
),
{
a!richTextDisplayField(
align: rule!replaceNull(
ri!align,
"CENTER"
),
value: {
a!richTextIcon(
icon: "angle-double-left",
size: "MEDIUM",
link: if(
property(
ri!pagingInfo,
"startIndex",
1
) <> 1,
a!dynamicLink(
saveInto: {
a!save(
ri!pagingInfo,
a!pagingInfo(
startIndex: 1,
batchSize: property(
ri!pagingInfo,
"batchSize",
- 1
),
sort: property(
ri!pagingInfo,
"sort",
null
)
)
),
ri!saveInto
}
),
null
),
linkStyle: "STANDALONE"
),
a!richTextIcon(
icon: "angle-left",
size: "MEDIUM",
link: if(
property(
ri!pagingInfo,
"startIndex",
1
) <> 1,
a!dynamicLink(
saveInto: {
a!save(
ri!pagingInfo,
a!pagingInfo(
startIndex: max(
1,
property(
ri!pagingInfo,
"startIndex",
1
) - property(
ri!pagingInfo,
"batchSize",
0
)
),
batchSize: property(
ri!pagingInfo,
"batchSize",
- 1
),
sort: property(
ri!pagingInfo,
"sort",
null
)
)
),
ri!saveInto
}
),
null
),
linkStyle: "STANDALONE"
),
a!richTextItem(
text: concat(
" ",
min(
ri!totalCount,
property(
ri!pagingInfo,
"startIndex",
1
)
),
" - ",
min(
ri!totalCount,
property(
ri!pagingInfo,
"startIndex",
1
) + if(
property(
ri!pagingInfo,
"batchSize",
- 1
) = - 1,
ri!totalCount,
property(
ri!pagingInfo,
"batchSize",
- 1
)
) - 1
)
),
style: "STRONG",
size: "STANDARD"
),
a!richTextItem(
text: concat(
" of ",
ri!totalCount,
" "
),
style: "STRONG",
size: "STANDARD"
),
a!richTextIcon(
icon: "angle-right",
size: "MEDIUM",
link: if(
property(
ri!pagingInfo,
"startIndex",
1
) <> local!maxStartIndex,
a!dynamicLink(
saveInto: {
a!save(
ri!pagingInfo,
a!pagingInfo(
startIndex: min(
local!maxStartIndex,
property(
ri!pagingInfo,
"startIndex",
1
) + property(
ri!pagingInfo,
"batchSize",
0
)
),
batchSize: property(
ri!pagingInfo,
"batchSize",
- 1
),
sort: property(
ri!pagingInfo,
"sort",
null
)
)
),
ri!saveInto
}
),
null
),
linkStyle: "STANDALONE"
),
a!richTextIcon(
icon: "angle-double-right",
size: "MEDIUM",
link: if(
property(
ri!pagingInfo,
"startIndex",
1
) <> local!maxStartIndex,
a!dynamicLink(
saveInto: {
a!save(
ri!pagingInfo,
a!pagingInfo(
startIndex: local!maxStartIndex,
batchSize: property(
ri!pagingInfo,
"batchSize",
- 1
),
sort: property(
ri!pagingInfo,
"sort",
null
)
)
),
ri!saveInto
}
),
null
),
linkStyle: "STANDALONE"
)
}
)
},
{}
)
)