paginate icon indicating copy to clipboard operation
paginate copied to clipboard

add multi-like filter (mlike)

Open gipsh opened this issue 3 years ago • 1 comments

  • mlike filter allows to search using like in many fields
  • example http://localhost:3000/?filters=["name,summart,title","mlike","john"]
SELECT * FROM user WHERE name LIKE '%john%' OR summary LIKE '%john%' OR title LIKE '%john%'  LIMIT 10 OFFSET 0
  • you can achieve same behaviour chaining many likes but the filter strings grows too much

gipsh avatar Sep 25 '21 02:09 gipsh

very interesting. I think this is a smart proposal.
may i merge yours into like, not like, ilike and not ilike operators?
this will be the default behavior, but I might add some changes. thanks

morkid avatar Oct 13 '21 14:10 morkid

PR #18

morkid avatar Jun 27 '24 09:06 morkid