Multiple Query Filter Options

Certified Senior Developer

Hello All,

In the filter parameter of a!recordFilterList(), I wanted to pass multiple query filter in order to filter the dropdown list using a!recordFilterList(),

per the documentation I do not see any feasible way to do it.

Kindly suggest a way out

Thanks & Regards

Girish Katti

a!recordFilterList(
    name: "Name",
    options: a!forEach(
      items: local!completeList,
      expression: a!recordFilterListOption(
        id: fv!index,
        name: if(
          exact(fv!item, local!name),
          " ",
          fv!item
        ),
        filter: 
        a!queryFilter(
          field: 'recordType!name',
          operator: "includes",
          value: tostring(fv!item)
        )
      )
    ),
    allowMultipleSelections: true()
  )

  Discussion posts and replies are publicly visible

  •   I believe what you are asking is if you can put multiple filters in the recordFilterListOption function. If that is the case right now it is not possible. Please correct me if I'm wrong.

    Also, it is not intended for the purpose of filtering by multiple values, you are basically creating the list of values for a filter drop-down and by selecting allowMultipleSeletion you allow passing multiple values to the actual query that the record uses. 

  • 0
    Certified Senior Developer
    in reply to sureshgunawardane

    Hello Suresh,

    I agree with do not have a option to use multiple filters at this time, but as a recommendation the Appian Product team should look at this request.

    All the points you have mentioned in the second statement is already in place and appreciate your quick response.

    Thanks & Regards

    Girish Katti