Question

User filter-Records

Forum|Forum|4 months ago
April 3, 2026
13 replies
0 views

I am creating a user filter,for completed by we have stored the value in userId ,while showing in record list using user function ,I need to sort the filter options.Is there anny possible way can someone help me

For the below example let's say,I want to sort the usernames in alphabetical order.

a!localVariables(
local!acctExecs: getdistinctusers(cons!ACCOUNT_OWNERS),
a!recordFilterList(
name: "Account Executives",
options: a!forEach(
items: local!acctExecs,
expression: a!recordFilterListOption(
id: fv!index,
name: user(fv!item, "firstName") & " " & user(fv!item, "lastName"),
filter: a!queryFilter(
field: recordType!Customer.fields.AccountOwner,
operator: "=",
value: fv!item
)
)
)
)
)

shubhama926776

Can you try this

a!localVariables(
  local!acctExecs: getdistinctusers(cons!ACCOUNT_OWNERS),
  local!mappedUsers: a!forEach(
    items: local!acctExecs,
    expression: a!map(
      username: fv!item,
      displayName: user(fv!item, "firstName") & " " & user(fv!item, "lastName")
    )
  ),
  local!sortedUsers: todatasubset(
    local!mappedUsers,
    a!pagingInfo(
      startIndex: 1,
      batchSize: -1,
      sort: a!sortInfo(field: "displayName", ascending: true)
    )
  ).data,
  a!recordFilterList(
    name: "Account Executives",
    options: a!forEach(
      items: local!sortedUsers,
      expression: a!recordFilterListOption(
        id: fv!index,
        name: fv!item.displayName,
        filter: a!queryFilter(
          field: recordType!Customer.fields.AccountOwner,
          operator: "=",
          value: fv!item.username
        )
      )
    )
  )
)