search

agentejo / cockpit

Add content management functionality to any site - plug & play / headless / api-first CMS
http://getcockpit.com
MIT License
5.4k stars 524 forks source link

Filter and combining And & Or #1506

Closed stefanKP50 closed 10 months ago

stefanKP50 commented 10 months ago

Hi, is there a way (sqlite) to combine $and and $or in filter request ? Schema is to select posts events having start date or end date between 2 dates.

Thanks Love cockpit V1

stefanKP50 commented 10 months ago

ok, found response in mongoDb doc. Logical is inverse as in sql query. First use $or as an array, then inside use $and objects. S.K