Report - complex filter

[mah1]

Vancouver Patch 5

We created a report for a specific assignment group on the task table. This report lists active tasks for that assignment group where the state is not resolved and assigned to is empty.

We have been requested to filter out change requests/tasks where the start date is empty.  So, we need to add a condition like the following:

(task type is not change request and task type is not change task) OR ((task type is change request or task type is change task) and start date is not empty)

I don't see a way to do this using the condition builder. Is there a way to include parens so that the conditions are evaluated correctly? How can you define complex conditions for a report?

Thank you

[AndersBGS · Accepted solution]

Hi @mah1 ,

Something like below should be able to solve your request:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[mah1]

Duh!  That will probably work.  I will try it out shortly and let you know.

Thank you!