Include operator not working in Query Entity with PostgreSQL Database

Hello all,

We are retrieving a row data from Database using query entity. 

In query filter we have a condition to get a row data.


field: "name",
operator: "includes",
value: ri!status

Database having status value as "awaiting_info" I need to get the row data irrespective of case sensitive like (ri!status= "awaiting_info" or "AWAITING_INFO" or "AWAITING_info" or "awaiting_INFO") .

On the "status" fields in the postgreSQL data base side applied the  case_insensitive COLLATION .But wherever we have applied the case_insensitive COLLATION, those colums are not supporting the  "include" operator from the query entity from Appian expression rule.

Any suggestion on this !!! 

  Discussion posts and replies are publicly visible