I wonder whether you could have a calculated boolean attribute on Change that shows as TRUE if All tasks are in "Completed" Status. You test on this boolean in your QT query.
Then in the calculation itself do all of the hard work and the return value is the boolean value.
(1) Set return value to FALSE
(2) Find "total" number of Tasks on the change and store in variable
(3) Loop round all tasks on that change and "subtotal" if they are in status "Completed"
(4) compare "subtotal" with "total" and if equal then return "TRUE", else "FALSE"
Maybe those more advanced on the BOO editor can advise.
Just an approach that occurs to me.
Of course forgot to say you'd need to be on 7.3
Yeah, we're only on 7.2.5 and unlikely to upgrade in the immediate future, otherwise your suggestion sounded great
1 of 1 people found this helpful
I don't think there is way just using the Query Designer that we can solve that for you. The only way that I can see this being cracked in 7.2.5 would be to have an automatic step in the process that detects when all Tasks are completed (All Tasks At End State?) and then moves the process on to a new status that reflects that. You can then write the query on the new status. I appreciate that is the a process based solution to a query question, but without the luxury of the new calculation tool in 7.3 (Julian's suggestion is pretty much spot on.), I think it's the most robust answer.