Pull project custom fields on a proof report

[NishaPatel]

Hi All,

I had previously raised a question is we can pull the project name in the proof report? I received the below answer which worked perfectly fine:

displayname=Project Name
valuefield=documentVersion:document:project:name
valueformat=HTML

Now I need to pull another field value in the report from the project. It is a custom field. Any idea how to do that?

Thanks,

Nisha 

[Richard_Le_ · Accepted solution]

Hi Nisha,

It's just a case of adding the field name to the value field part of the code:

displayname=NAME
valuefield=documentVersion:document:project:DE:CUSTOM FIELD NAME
valueformat=HTML

Simply replace the pink text with the name of your custom field (note that the field name must be pre-fixed with "DE:")  and you should find that this works.

Best Regards,

Rich.

[NishaPatel]

Thanks Richard, I was trying with just the name of the field and it never worked. Adding DE: in the beggingin of the field name did the magic. Thank you again

[NishaPatel]

Hi @Richard_Le_ ,

Do you know how to group by this field? 

Thanks,

Nisha

[Richard_Le_]

Hi Nisha,

Try the following:

group.0.valueexpression={documentVersion}.{document}.{project}.{DE:CUSTOM FIELD NAME}
group.0.valueformat=HTML
textmode=true

Note that you wont be able to create a chart using a text mode grouping. The grouping will only work in the list view.

Best Regards,

Rich

[NishaPatel]

Hi Richard,

Many thanks. This has worked Thanks for the advance note on Charts, I would have asked this question next.

Thank you so much,

Nisha