How can I achieve this type of sorting using queryrecord?

Question

I am facing problem with sorting the data using query record. I want to fetch data from the data store using queryrecord sorted on the basis of two columns (say Column1, Column2) just like we do using ORDER BY CLAUSE in SQL. How can I achieve this type of sorting using queryrecord. Many thanks in advance -Sandeep ... 
 OriginalPostID-93530 
 OriginalPostID-93530

Patty Isecke · Accepted Answer

Take a look at the Common Objects App: forum.appian.com/.../Appian_Common_Objects_Application

Within the definition for your APN_queryAggregation(), define your aggregationColumns:

For example:
=queryrecord(
recordType: cons!YOURRECORDTYPE,
query: rule!APN_queryAggregation(
aggregationColumns: {
rule!APN_aggregationColumn(
field:"field1"
),
rule!APN_aggregationColumn(
field:"field2"
)
},
pagingInfo:
)
)