- Strapi Version: 4.1.0
- Operating System: Docker
- Database: SQLite
- Node Version: v14.19.0
I’m looking for a way to filter entries through API requests with conditions based on relations.
Here is a backdrop:
[Collection Type - Users] name email Relation -> can have many Activities [Collection Type - Activities] date Relation -> should belong to a single user
What I’m trying to achieve is a request like this:
(Easy/done) → show me users that were active at the date1
(Easy/done) → show me users that were active before date1
(Hard/idk) → show me users that were active after the date1 but were not active before the date2
The problem is when the user has 2+ activities and I request users list with $and for activities, it matches any of the items in activities, but instead, I’m looking for a way to say “show me users that were active after date but were not active before date”.
Thanks in advance for any reply!