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.
Example
a!queryFilter(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