Specific Task report | Community
Skip to main content
November 28, 2023
Solved

Specific Task report

  • November 28, 2023
  • 2 replies
  • 1044 views

I am trying to create a task report that shows all current projects that have this task. I am only able to show the task if I select a filter for the Task Name and select each project from the pulldown option when adding filters to the report. 

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

Lyndsy is correct in that "contains" is the proper filter modifier if you're using the wizard. In text mode, you would use "cicontains" so it's not case sensitive.

When you use the wizard (not textmode) and the "equals" modifier, it automatically, and in the backend changes "name" to "ID" so you don't end up with a gazillion returns in your payload. If you actually want to match the name and not the ID, you should not use "equals".

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

 

2 replies

Lyndsy-Denk
Community Advisor
Community Advisor
November 28, 2023

For a more immediate solution, if you can use "Contains" instead of "Equal to," you should be able to filter all tasks of that name.

Better yet, use milestone paths. When you have milestones in place, you filter your task report on all tasks with a certain milestone. I use this to plot an asset's deploy date on a calendar.

AC-againAuthor
November 29, 2023

The issue that I have is that "Contains" is not an option in the pulldown menu.

 

RandyRoberts
Community Advisor
RandyRobertsCommunity AdvisorAccepted solution
Community Advisor
November 29, 2023

Lyndsy is correct in that "contains" is the proper filter modifier if you're using the wizard. In text mode, you would use "cicontains" so it's not case sensitive.

When you use the wizard (not textmode) and the "equals" modifier, it automatically, and in the backend changes "name" to "ID" so you don't end up with a gazillion returns in your payload. If you actually want to match the name and not the ID, you should not use "equals".

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

 

AC-againAuthor
November 29, 2023

Once I switch back to "Task - Name" I was able to see "Contains" in the pulldown and the report worked as expected. Thanks.