[User Filter] Filter KO when data begins with the letter "T" ?!

A Score Level 2

Hello everyone,

I encounter a weird problem (bug ?) with expression based user filter on record list : I created a rule that works just fine on any environment, any record and any text field, except with data that begins with the letter "T" !
Do you have the same behavior ?

1. The Setup

I created an expression rule (called "AMO_RecordFilterList") to call when setting a record user filter.

The rule inputs are :

The rule is :

a!localVariables(
  local!filtre_list: a!queryEntity(
    entity: ri!entity,
    query: a!query(
      aggregation: a!queryAggregation(
        aggregationColumns: {
          a!queryAggregationColumn(
            field: ri!field,
            isGrouping: true
          )
        }
      ),
      pagingInfo: a!pagingInfo(
        1,
        - 1,
        a!sortInfo(
          ri!field,
          true
        )
      )
    ),
    fetchTotalCount: true
  ),
  a!recordFilterList(
    name: ri!title,
    options: {
      a!forEach(
        items: local!filtre_list,
        expression : a!recordFilterListOption(
          id: fv!index,
          name: if(
            or(isnull(index(fv!item,ri!field)),index(fv!item,ri!field)=""),
            "(vide)",
            index(fv!item,ri!field)
          ),
          filter: a!queryFilter(
            field: ri!field,
            operator: if(
              or(isnull(index(fv!item,ri!field)),index(fv!item,ri!field)=""),
              "is null",
              "="
            ),
            value: if(
              or(index(fv!item,ri!field),index(fv!item,ri!field)),
              null,
              index(fv!item,ri!field)
            )
          )
        )
      )
    },
    allowMultipleSelections: if(isnull(ri!allowMultipleSelections),true(), ri!allowMultipleSelections)
  )
)

2. The use

In a Record User Filters configuration, I call this rule and give it my rule inputs :

The user filter works fine...

... and returns the expected lines :

3. The Problem

This rule works fine in any environement, with any record and any field except with records which data text field begins with the letter "T" (upper case or not)

After a few investigations :

  • The problem happens in any environement, with any record, as soon as the data begins with a "T" or a "t"
  • The affected lines are displayed in the record list if the filter is not used or if other filter are used
  • The filter works fine if I type a a!recordFilterList function directly in the user filter configuration

I came with the "T" issue after using that same rule in another environement and having exactly the same problem.

Does anyone reproduces the problem and have any insight ?

(thank you for reading me this far !)

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data