Hi AllWhen i am doing filtering not getting expected output.Below code is mentioneda!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 outputWhen i searched " Research" (added 2 spaces initially) and it is not returning any output which is expectedWhen 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