12 replies

Filter based on join data

Hi, would it be possible to query a list of student and filter by the name of its coach. The data is

<student>.coach.fullname

<student>.coach.fullname

where coach is added as a

with

with

join. I would like to get every student that have a certain coach.