Hi,
I have Multiple Column and Rows fields.
- Column: Year (i.e 2018, stored as a int (tried DateTime and String also) and Month (i.e April, stored as DateTime)
- Row: Name (i.e. Lee Stevens, stored as String) and Charge Type (i.e. Annual Leave, stored as String)
Now, when i sort ONLY the columns OR row, the results display as they should but when i want to Sort from both it "can't" I guess and gives up.
For example when i sort the Column (Year, Month)
sort: [
{
field:
"Year"
,
dir:
"desc"
//or asc
},
{
field:
"Month"
,
dir:
"asc"
//or asc
}
]
This work perfectly fine, It display the Year(s) (i.e. 2018, 2017, 2016) then the Months in order (I.e. Jan, Feb, March)
But as soon as i introduce the sorting the row also they then stop ordering correctly:
sort: [
{
field:
"FullName"
,
dir:
"asc"
//or asc
},
{
field:
"Year"
,
dir:
"desc"
//or asc
},
{
field:
"Month"
,
dir:
"asc"
//or asc
}
]
The order becomes: 2017, 2019, 2018. Nov, Dec, April, Jan (they seem to loose there sorting?)
Any ideas?
Thanks,
Lee.