Expand my Community achievements bar.

SOLVED

Adding Project Name to a Proof Approval Report

Avatar

Level 7

I'm assuming this isn't possible but I had a Proof Approval Report and I'd like to add the name of the associated Project for each Proof Approval.

If it is possible, I'd love to know how. (Or, if not possible, any way to aggregate a proof with the project in which it belongs.

Thanks!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

@John O'Sullivan‚ It can be done through text mode! in your Proof Approval report, add a column, switch to text mode and paste the following:

displayname=Project Name

textmode=true

valuefield=documentVersion:document:project:name

valueformat=HTML

If you would prefer to group the results by the project name, you can add a grouping, switch to text mode and paste the following:

group.0.displayname=Project Name

group.0.valuefield=documentVersion:document:project:name

group.0.valueformat=HTML

textmode=true

If you have any questions or run into any issues, let me know!

View solution in original post

4 Replies

Avatar

Correct answer by
Employee Advisor

@John O'Sullivan‚ It can be done through text mode! in your Proof Approval report, add a column, switch to text mode and paste the following:

displayname=Project Name

textmode=true

valuefield=documentVersion:document:project:name

valueformat=HTML

If you would prefer to group the results by the project name, you can add a grouping, switch to text mode and paste the following:

group.0.displayname=Project Name

group.0.valuefield=documentVersion:document:project:name

group.0.valueformat=HTML

textmode=true

If you have any questions or run into any issues, let me know!

Avatar

Level 7

That did the trick Nicole! (I should have looked at the API Explorer--bad John! Now I know!

Thanks again!

-j

Avatar

Level 1

Hello Nichole,

 

What text mode could we use for grouping by Project Owner?

Apprecite the help.

 

Thank you

Cliff

Avatar

Level 4

is there a way to create a link to the actual project in the column?  link.value=????