how to sort the text field integer values

Question

Can any on help me for "how to sort the text field integer values", 
 
 example i have field name: data it is text field but in that field values are stored 10,000 and 80,000 and 20,000 so i want to sort those values if anyone know can you please help me with it?

Stefan Helzle · Accepted Answer

To sort data, you need to wrap it into a datasubset using the todatasubset() function and a paging info. 
 Some inspiration: 
 - https://docs.appian.com/suite/help/22.4/fnc_scripting_todatasubset.html#examples 
 - docs.appian.com/.../Function_Recipes.html

gayathris0003 · Answer

todatasubset(
a!forEach(
ri!array,
{
name: fv!item
}
),
a!pagingInfo(
startIndex: 1,
batchSize: -1,
sort: a!sortInfo(
field:"name",
ascending: true
)
)
).data.name

OR

todatasubset(
{ { name: 100 }, { name: 10 }, { name: 80 } },
a!pagingInfo(
startIndex: 1,
batchSize: - 1,
sort: a!sortInfo(field: "name", ascending: true)
)
).data.name

how to sort the text field integer values

Top Replies