Nested Document Search Query (searching across filtered nested documents)

I have nested document like
attendance[{class: "physics", Joined: "2021-01- 21", "grade": "pass"}
, {class: "chemistry", Joined: "2021-01- 13", "grade": "NA"}, {class: "maths", Joined: "2021-01- 18", "grade": "fail"}]}
I need to search for documents which have a user attending a physics class in last week from today, (i.e between 20th and 27 )and who hasnt attended any other class between a week from the day he had attended that physics class (here in this example between 14 - 20th jan, since physics class was attended on 21st jan)

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.