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
I've tested this and can reproduce this behavior in 25.2. It's possible that QueryEntity simply trims traling spaces. If you're not sure if this behavior is intended, and/or it's causing you issues you are having trouble getting around, then I would encourage you to open a support case with Appian.