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
What is the type of APPORVAL_DATE within your CDT? The behavior you describe sounds as if it's sorting these values as if they were plaintext.
My theory as well, it looks like it's trying to alphabetize your dates rather than count them. I don't know if an explicit cast inside your sort statement will help, but that's what I would try first.
From further comments in the earlier thread it looks like the data is coming in (perhaps in plaintext) via an API call. I'd guess that some transform could be done on the data prior to sorting, though that depends on a lot of factors and would grow pretty complicated pretty quickly.
Thank you Mike Schmitt
Casting prior to sorting is working for me.