[v4] REST API filtering within relations

Questions and Answers
1
System Information
  • Strapi Version: 4.1.0
  • Operating System: Docker
  • Database: SQLite
  • Node Version: v14.19.0

Greetings!

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!

1 Like