Hello Everyone,
I am using below pagingInfo , gridcolumn , and pagingSaveInto in my interface where Approval Date is of datetime type
local!pagingInfo: a!pagingInfo(
startIndex:1,
batchSize: -1,
sort: a!sortInfo(field: "APPORVAL_DATE")
gridColumn(
label: "Approved On",
sortField: "APPORVAL_DATE",
value: fv!row.APPORVAL_DATE
)
pagingSaveInto: local!pagingInfo
If approval date is between 7/1/2021 and 7/12/2021 then
Expected result to be sorted by Date ie. 7/12, 7/11, 7/10, 7/9, 7/8, 7/7 and so on but sorting is not applied to the grid and resulting data is random sequence like 7/11 7/12 7/1 7/2 and so on.
Thank you for suggestions in advance.
Discussion posts and replies are publicly visible
Thank you Selvakumar Kumarasamy.
Casting the API result before sorting worked for me.
Thank you Mike Schmitt
Casting prior to sorting is working for me.
You are aware that fetching ALL data into Appian will become a serious issue as your data volume increases?
Thank you for this helpful suggestion
It is an POC which I am currently working on. I will be doing filtering and sorting at API end when I will get into dev.