Is it possible to use a!sortInfo to sort by field1 and then by field2?

cherylr over 9 years ago

Is it possible to use a!sortInfo to sort by field1 and then by field2?

I tried the following code, but I am getting an error " Invalid Cast: Cannot cast from type 'PagingInfo' to type 'Date': CastInvalid"

a!sortInfo({
{field:"field1",ascending:false)},
{field:"field2",ascending:false)}
})

Discussion posts and replies are publicly visible

Parents

0 Conor Cahill
Certified Lead Developer
over 9 years ago

You could run the queryEntity without sorting, and then push that through a todatasubset(), applying the sorting. Depending on the size of your dataset this may be a slow way to do what you want.

You could also add a column that is some sort of combination of the multiple columns you want to sort by (e.g. column1.column2), and then sorting by only this new column will essentially sort by column1 then column2.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Conor Cahill
Certified Lead Developer
over 9 years ago

You could run the queryEntity without sorting, and then push that through a todatasubset(), applying the sorting. Depending on the size of your dataset this may be a slow way to do what you want.

You could also add a column that is some sort of combination of the multiple columns you want to sort by (e.g. column1.column2), and then sorting by only this new column will essentially sort by column1 then column2.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data