Query Entity - Filter Searching not working

Hi All

When i am doing filtering not getting expected output.

Below code is mentioned
a!queryEntity(
entity: cons!LOCALE_TRANSLATION_NEW,
query: a!query(
selection: if(
rule!P3_utils_checkIsNullOrEmpty(ri!columns),
{},
a!querySelection(
columns: a!forEach(
items: ri!columns,
expression: a!queryColumn(field: fv!item, alias: fv!item)
)
)
),
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "label_txt",
operator: "=",
value: ri!label_txt,

),

},
ignoreFiltersWithEmptyValues: true
),
pagingInfo: if(
rule!P3_utils_checkIsNullOrEmpty(ri!pagingInfo),
a!pagingInfo(
startIndex: 1,
batchSize: cons!P3_BATCH_SIZE[7]
),
ri!pagingInfo
)
),
fetchTotalCount: and(ri!isFetchTotalCount)
)


=======================================
When i searched "Research". It is giving me expected output


When i searched "  Research" (added 2 spaces initially) and it is not returning any output which is expected

When i searched "Research  " it is giving me output as "Research"


Is it default behavior of Appian ?




Expected result - It should not return anything because there is no label like "Research  " in DB tables


  Discussion posts and replies are publicly visible