Sort a CDT array based on a field

The following snippet should help you - local!field would be the field name you want to sort on.

cast(
  typeof(local!cdt),
  todatasubset(
    local!cdt,
    a!pagingInfo(
      startIndex: 1,
      batchSize: -1,
      sort: a!sortInfo(
        field: local!field,
        ascending: local!ascending
      )
    )
  ).data
)

Hi Josh,

is it possible to sort on two field in a CDT? just like in SQL, it can set like "ORDER BY Field1 ASC, Field2 ASC".

regards,

Lin

i think I know it now. thanks.

Yes.  When sorting using an a!pagingInfo() object, an array of a!sortInfo() objects may be passed in and all of them will be used (in order) to sort the resulting array.

Yes.  When sorting using an a!pagingInfo() object, an array of a!sortInfo() objects may be passed in and all of them will be used (in order) to sort the resulting array.