Expand my Community achievements bar.

SOLVED

How to filter a project report based on task status where a task level custom attribute is of a certain value?

Avatar

Level 3

We have a task level custom field named "Sub Milestone" (internal reference is DE:tasks:Sub Milestone). We would like to create a project report to find any projects where DE:tasks:Sub Milestone=MARKETING APPROVED and that task's status is completed (CPL). I'd really appreciate any suggestions on how to accomplish that.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

can I interest you in this link?

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collec...

 

you're already 25% of the way there with your first line. You just needed the "DE:tasks:Sub Milestone_Mod=in" line, and then 2 more lines for the status, "tasks:status=CPL" and "tasks:status_Mod=in"

 

Reporting on collections is super easy because for the most part you can steal all of your text mode from a task report and just put it into a project report and append "tasks:" to the front of every system line, or after the "DE:" for every custom field line. Then for the most part, your task report turns into the validation report for your project report (group by project ID, and run a quick count between the two reports)

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

can I interest you in this link?

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collec...

 

you're already 25% of the way there with your first line. You just needed the "DE:tasks:Sub Milestone_Mod=in" line, and then 2 more lines for the status, "tasks:status=CPL" and "tasks:status_Mod=in"

 

Reporting on collections is super easy because for the most part you can steal all of your text mode from a task report and just put it into a project report and append "tasks:" to the front of every system line, or after the "DE:" for every custom field line. Then for the most part, your task report turns into the validation report for your project report (group by project ID, and run a quick count between the two reports)

Avatar

Level 3

Thank you for the answer! This resolves it!