We have a list of Changes sitting at "Review" status - currently, we return all of these in a workload list.
Most of these Changes will have al least one Task off it.
I have written a Query that selects Changes where "Tasks.Status Is Equal to (Completed) AND Status Is Equal to (Review)"
This works nicely as long as Changes only have a single Task.
If a Change has more than one, it will be returned on this Query as long as ANY of the Tasks are complete.
Is there any way to only return Changes where ALL the Tasks are complete ?
Also, some Changes have no tasks - can I amend my query to include these ?