Looking to add custom form date field as a column in a document report

[AWoody]

I am looking to add a custom date field as a column in a document report. After looking for solutions in Experience League I found that this worked for someone, but not for me (I have adjusted it to be relevant to me):

displayname=T Date
valueexpression={document}.{project}.{DE:T Date}
valueformat=HTML

Where am I going wrong as the column is blank?

Thank you

[Richard_Le_]

Hi,

Assuming that the date field is being captured on a project custom form (as your text mode suggests), you shouldn't need to use text mode at all. The Project object and it's data attributes are all available natively from a Document report. In the report builder, simply add a column and search for the "T Date" field, it should appear under the project attributes:

Best Regards,

Rich.

[AWoody]

Thanks Rich - I was wrong, it is a proof approval report ...

Why has Workfront removed what type of report it is out of Filters? How can we now find out?

[Sven-iX]

Hi @AWoody 
The short answer is: You can't. 

Proof Approval reports don't support objects that are, ostensibly, linked to the document object. 

For example you can include "projectID" - but creating a column for "project:name" will give you blanks. 

Maybe this will work for your use case: 

1. Create a DOCUMENT report
2. Filter currentVersion:proofDecision = notblank

On DOCU reports you can access objects that are referenced from the document, e.g. project etc. So you can pull in custom fields on a project. 

[kautuk_sahni]

@AWoody Just checking in — were you able to resolve your issue?
We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!