Search a thing with constraint on a One-to-Many relationship

spa.sc · 2025-03-18T14:10:59.773Z

1- I have a type Project and a type Task. One project can have multiple tasks.
2- A Task has a yes/no field ‘IsCompleted’ that indicates if the task is completed or not.

How can I retrieve the all the projects that have uncompleted tasks?
How can I put a condition on a join between Project and Task?

romanmg · 2025-03-18T14:13:46.925Z

If you have a Project field on the Task data type, then you can do:

Search for Tasks (IsCompleted = no)'s Projects :unique elements

spa.sc · 2025-03-18T14:29:55.022Z

It works. So cool. Thanks.