I have a task report that shows the value of the Parent task and I want to omit some values | Community
Skip to main content
B
BillPe
Level 3
September 10, 2024
Question

I have a task report that shows the value of the Parent task and I want to omit some values

  • September 10, 2024
  • 3 replies
  • 1493 views

I have a task report that shows the value of the Parent task and I want to omit some values (example: Monitor/Control).  Here is a snippet of some tasks with Monitor/Control

Here is my filter:

DE:project:Project Type=Customer Sponsored Operational Project
DE:project:Project Type_Mod=in
project:status=CUR
project:status_Mod=in
task:numberOfChildren=0
task:numberOfChildren_Mod=eq
task:parent=Monitor/Control
task:parent_Mod=notin
task:status=INP NEW
task:status_Mod=in

But as you can see the lines with Monitor/Control is still showing

 

Any assistance is appreciated

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
September 10, 2024

Hi there,

Try swapping this:
task:parent=Monitor/Control
task:parent_Mod=notin

With this:

parent:name=Monitor/Control
parent:name_Mod=cinotcontains
I also made it 'does not contain' instead of 'not equal' in case someone ever slightly rewords it, you still don't want any version of Monitor/Control.

If this helped you, please mark correct to help others : )
RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
September 10, 2024

lol, we were both answering this at the same time!

B
BillPeAuthor
Level 3
September 10, 2024

Sorry Randy the report is an assignment report not a task report

RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
September 10, 2024
parent:name=Monitor/Control parent:name_Mod=notin

If you're in a Task report, you don't need the "task" part as it is implied. you do however need the "name" part.

DE:project:Project Type=Customer Sponsored Operational Project DE:project:Project Type_Mod=in project:status=CUR project:status_Mod=in numberOfChildren=0 numberOfChildren_Mod=eq parent:name=Monitor/Control parent:name_Mod=notin status=INP NEW status_Mod=in

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

 

B
BillPeAuthor
Level 3
September 10, 2024

Sorry the report is an assignment report

RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
September 10, 2024

This should work then:

DE:project:Project Type=Customer Sponsored Operational Project DE:project:Project Type_Mod=in project:status=CUR project:status_Mod=in task:numberOfChildren=0 task:numberOfChildren_Mod=eq task:parent:name=Monitor/Control task:parent:name_Mod=cinotcontains task:status=INP NEW task:status_Mod=in
B
BillPeAuthor
Level 3
September 10, 2024

I now get the below error message

 

An error has occurred and we are working to resolve the issue. To continue with your work, try refreshing this browser page.

Terms & ConditionsAccessibility statement

Loading footer...