Skip to main content
November 25, 2024
Question

The record filter is not updating after performing a record action.

  • November 25, 2024
  • 3 replies
  • 0 views

While adding or deleting records in the grid, the filter values are not refreshing automatically. Although the record syncs successfully, the issue persists specifically with the filters, requiring a manual page refresh to reflect the changes.

Below filter code 

a!recordFilterList(
  name: "Name",
  options: a!forEach(
    items: index(
      rule!MWM_QRD_getExternalUserData(
        filters: a!queryFilter(
          field: 'recordType!{33ea4758-97d4-474a-82f2-274f130f5bee}MWM External User.fields.{7ff5fb03-52c4-49cf-ad2d-42f1379be38e}isActive',
          operator: "=",
          value: true()
        ),
        totalCount: false,
        
      ),
      "data",
      'recordType!{33ea4758-97d4-474a-82f2-274f130f5bee}MWM External User.fields.{3ea25a9f-4b80-419f-bf3d-fedf3782448a}userId',
      {}
    ),
    expression: a!recordFilterListOption(
      id: fv!index,
      name: rule!MWM_RULE_UTILS_displayUser(user: fv!item),
      filter: a!queryFilter(
        field: 'recordType!{33ea4758-97d4-474a-82f2-274f130f5bee}MWM External User.fields.{3ea25a9f-4b80-419f-bf3d-fedf3782448a}userId',
        operator: "=",
        value: fv!item,
        applyWhen: a!isNotNullOrEmpty(fv!item)
      )
    )
  ),
  isVisible: true,
  
)

3 replies

stefanhelzle0001
November 25, 2024

I think that Appian does not refresh filter options out of performance reasons.

November 25, 2024

Then is there any way to achieve this part ?

stefanhelzle0001
November 25, 2024

You could implement your filters separately in an interface instead of record user filters.