How to query the DB with the ILIKE filter


#1

When I am querying my table with the Like function, the result doesn’t display different case results.

For example, if I am specify a filter “column like %washington” it doesn’t display the result which has “Washington”. How can I build my query in such a fashion that the results are displayed. I am connecting to a Postgres DB but I don’t think dreamfactory supports the ILIKE function


#2

Are you sure, your syntax is correct. I do requests with “LIKE %”+ and it works perfectly.


#3

ILIKE, capitalized or not, still doesn’t work in DreamFactory as of November 30, 2017. I’m using Postgres. Filter is: first_name ilike j%.

Request:
members?filter=first_name%20ilike%20j%25

{
“error”: {
“code”: 400,
“context”: null,
“message”: “Invalid or unparsable filter request.”,
“status_code”: 400
}
}


#4

@jmpreston I imagine not, ILIKE is a PostGres specific extension of the SQL LIKE. DreamFactory applies SQL Standard (ANSI) across the board for all relational databases. If ILIKE was working previously it is purely coincidental or maybe just a hidden feature you’ve unlocked :slight_smile: