Include operator not working in Query Entity with PostgreSQL Database

Question

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 !!!

Stefan Helzle · Answer

Found this: https://docs.appian.com/suite/help/23.4/fnc_system_a_queryfilter.html#case-sensitivity-on-record-types-with-data-sync-enabled 
 But that does not directly answer your question. 
 I only use constant text values to store and check against such fields. That avoids this issue altogether. 
 --- A few minutes later --- 
 Did a small test with MariaDB. The "includes" operator performs a case insensitive search. 
 Conclusion: Open a support case and report this behavior. I would a similar behavior with PostgreSQL.

Include operator not working in Query Entity with PostgreSQL Database

Top Replies