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

Questions
1

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?

2

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

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

3

It works. So cool. Thanks.

1 Like