Sort appian group members for dropdown

Question

Hi , How can I sort appian group members and bind to dropdown.

Harshit Bumb (Appyzie) · Answer

When you provide paging info for groupMembers, you can additionally pass these two fields in the sortInfo and control the sorting. 
 a!groupMembers(
 group: cons!GROUP,
 pagingInfo: a!pagingInfo(
 startIndex: 1,
 batchSize: 100,
 sort: {
 a!sortInfo(
 field: "groupName",
 ascending: true
 ),
 a!sortInfo(
 field: "username",
 ascending: true
 )
 }
 )
).data

Harshit Bumb (Appyzie) · Answer

You can just copy and paste this into your filter list, run a loop over it, and add the query filter. 
 a!recordFilterList(
 name: "Members",
 options: a!forEach(
 items: a!groupMembers(
 group: cons!GROUP,
 pagingInfo: a!pagingInfo(
 startIndex: 1,
 batchSize: 100,
 sort: {
 a!sortInfo(
 field: "groupName",
 ascending: true
 ),
 a!sortInfo(
 field: "username",
 ascending: true
 )
 }
 )
 ).data,
 expression: a!recordFilterListOption(
 id: fv!index,
 name: fv!item,
 filter: a!queryFilter(
 field: recordType!Record.fields.fieldname,
 operator: "=",
 value: fv!item
 )
 )
 )
)

Sort appian group members for dropdown

Top Replies