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
New Participant
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
  • 1483 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

B
BillPeAuthor
New Participant
September 10, 2024

Sorry the report is an assignment report

RandyRoberts
RandyRoberts
New Participant
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
New Participant
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.

RandyRoberts
RandyRoberts
New Participant
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

 

Madalyn_Destafney
Madalyn_Destafney
New Participant
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
RandyRoberts
New Participant
September 10, 2024

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

B
BillPeAuthor
New Participant
September 10, 2024

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

Terms & ConditionsAccessibility statement

Loading footer...