Skip to main content
Level 2
Apr 2, 2025 10:57 AM UTC
Solved

Report filter based on task name & status combination

Hello,

I need to create a report to filter out 2 specific tasks:

1) Task 1 - Asset Audit

2) Task 2 - Build

 

I want to filter out projects where Task 2 is in progress and Task 1 is not complete.

Task 1 - Actual end date is blank & Task 2 - Actual start end is not blank

 

When I tried "OR" in the filter, it either shows Task 1 / Task 2. I need to filter out the combination of task 1 + status & task 2 + status. 

 

Is there a way to create a filter for this combination?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
skyehansen
skyehansenAccepted solution
Apr 4, 2025 4:35 PM UTC

Starting a new thread to address clarifications made by the OP

 

EXISTS:a:$$OBJCODE=TASK
EXISTS:a:actualStartDate_Mod=notnull
EXISTS:a:name=build
EXISTS:a:name_Mod=cicontains
EXISTS:a:projectID=FIELD:projectID
EXISTS:b:$$OBJCODE=TASK
EXISTS:b:actualCompletionDate_Mod=isnull
EXISTS:b:name=asset audit
EXISTS:b:name_Mod=cicontains
EXISTS:b:projectID=FIELD:projectID

16 replies

Sven-iX
Community Advisor
Community Advisor
Apr 2, 2025 10:15 PM UTC

Why are you using an OR filter? Your definition above sounds like you want to AND the 2 conditions? 

Translate
Level 2
Apr 3, 2025 9:08 AM UTC

Hi @sven-ix That is correct. We need to use AND. However, with that I'm unable to specify for which task I need the completion date and which should have only start date.

 

Could you please suggest if there is a way I could do that?

 

Translate
Sven-iX
Community Advisor
Community Advisor
Apr 3, 2025 9:58 AM UTC

Pls share what type of report this is and your current filter

Translate
skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community AdvisorAccepted solution
Apr 4, 2025 4:35 PM UTC

Starting a new thread to address clarifications made by the OP

 

EXISTS:a:$$OBJCODE=TASK
EXISTS:a:actualStartDate_Mod=notnull
EXISTS:a:name=build
EXISTS:a:name_Mod=cicontains
EXISTS:a:projectID=FIELD:projectID
EXISTS:b:$$OBJCODE=TASK
EXISTS:b:actualCompletionDate_Mod=isnull
EXISTS:b:name=asset audit
EXISTS:b:name_Mod=cicontains
EXISTS:b:projectID=FIELD:projectID

Translate
Level 2
Apr 7, 2025 10:06 AM UTC

This worked, thank you @skyehansen 

Translate