Does any one aware of sort ??

Certified Associate Developer

Hi,

BELOW Is SORT where we used 

a!save(local!a,

index(sort(somevalue)),1,Null)

Now after upgrading im getting error in interface invalid function {"SORT"}

WHAT is the replacement of SORT NOW

  Discussion posts and replies are publicly visible

Parents
  • The sort function is not documented by Appian and is not recommended for use in your code. Instead, adding to what Nilanshu said you can use todatasubset() function to sort your data by providing sortInfo, 
    eg : 

    a!localVariables(
      local!array: { 1, 11, 9, 2, 7, 0 },
      local!fieldArray: a!forEach(
        items: local!array,
        expression: a!map(id: fv!item)
      ),
      local!datasubset: fn!todatasubset(
        arrayToPage: local!fieldArray,
        pagingConfiguration: a!pagingInfo(
          startIndex: 1,
          batchSize: - 1,
          sort: a!sortInfo(field: "id", ascending: true)
        )
      ),
      local!datasubset.data.id
    )


    Additionally, if your 'somevalue' only contains integers/dates, the min() function would be a more efficient alternative in this scenario.

Reply
  • The sort function is not documented by Appian and is not recommended for use in your code. Instead, adding to what Nilanshu said you can use todatasubset() function to sort your data by providing sortInfo, 
    eg : 

    a!localVariables(
      local!array: { 1, 11, 9, 2, 7, 0 },
      local!fieldArray: a!forEach(
        items: local!array,
        expression: a!map(id: fv!item)
      ),
      local!datasubset: fn!todatasubset(
        arrayToPage: local!fieldArray,
        pagingConfiguration: a!pagingInfo(
          startIndex: 1,
          batchSize: - 1,
          sort: a!sortInfo(field: "id", ascending: true)
        )
      ),
      local!datasubset.data.id
    )


    Additionally, if your 'somevalue' only contains integers/dates, the min() function would be a more efficient alternative in this scenario.

Children
No Data