Search code examples
admin-on-rest

Are more advanced filters possible on Admin on Rest?


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"?


Solution

  • 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.