I am struggling to get get anywhere with more advanced filters.
Dates,
As far as I can see Admin-on-Rest
filter can only be "where":"field":"value"...}
.
It would be great if filter can included a date range. {"where":"field" between: "value1" and "value2" ...
like or regexp
Again, AOR's
filters are exact. Is it possible to use "like
" or "regexp
"?
MySQL & Loopback REST API backend:
in url:
filter={"where":{"field":{"regexp":"value"}}
works perfectly. value "star" will return "starboard", "deathstarzero", etc. No %
or *
are needed.
same for "less than" lt and gt
filter={"where":{"field":{"lt":"value"}}
in AOR js filter: { field: {lt:'value'}},
etc.