Journal Entry Reports - Project Name | Community
Skip to main content
Eric_D_Miller
Eric_D_Miller
Level 5
August 22, 2023
Solved

Journal Entry Reports - Project Name

  • August 22, 2023
  • 2 replies
  • 2044 views

I am attempting to pull a report to see how many times a certain file has been downloaded but I am hung up on which field to use to display / filter for the associated Project Name that the file is stored in. Currently my report is only looking for Journal Entries types that equal Download.

 

Does anyone know which field to use in order to see or filter the project the document is a part of?

 

Thank you

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 skyehansen

Oh, I see. This is kind of tough, but here's a sample column you could insert that will help underline where the problem is. 

 

displayname=This is where the journal entry is being stored linkedname=documentVersion namekey=view.relatedcolumn namekeyargkey.0=documentVersion namekeyargkey.1=documentID querysort=documentVersion:document:project:name textmode=true valuefield=documentVersion:document:project:name valueformat=HTML

 

If this column works on your side, you will see that the journal entry is only being stored on the Document Version. This means that in order to reference or filter for anything, you need to start there. So you can see that from the doc version, I was only able to reference the document. From there I had to use the document to reference the project, before being able to finally access the project name. Does this make sense so far?

2 replies

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
August 22, 2023

Hi Eric - if you are running a journal entry report you should be able to pull in column for Project name. Is that the kind of report you are using? 

 

 

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
August 22, 2023

You should also be able to filter by project name:

 

Eric_D_Miller
Eric_D_MillerAuthor
Level 5
August 22, 2023

Hi Kellie,

 

Yes this is a journal entry report. You can see in the screenshot that I attempt to view the project name in the report, but that does not return any results. The filters also seem to produce no results.

 

I have also tried...

Journal Entry>TopObjID

Document>TopObjID

Document>Project ID

 

with no sucess.

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
August 22, 2023

I suspect your answer is in this link somewhere:

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/create-manage-reports/create-journal-entry-report.html?lang=en 

 

Specifically this line.

 

The Journal Entry report contains only system updates from the Updates area of objects.

 

 

This is basically a report on the Updates area (for system update messages). If you don't see "download" as a system update (I mention this, because I can't see when people download files), you probably cannot report using a Journal Entry report.

Eric_D_Miller
Eric_D_MillerAuthor
Level 5
August 22, 2023

I am able to run the report to filter out Change Types = Download. This seems to pull in every Update that has to do with a file being downloaded which is too much data. We can narrow down by Entry Date, but that still doesn't quite get us the data we need.

 

 

 

This gets me some of the info I need but to make this perfect I need to be able to view/filter by the Project that the file exists in. I have highlighted what exactly I would like to view/filter in the report. Is it possible to pull that data in?

 

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
August 22, 2023

Oh, I see. This is kind of tough, but here's a sample column you could insert that will help underline where the problem is. 

 

displayname=This is where the journal entry is being stored linkedname=documentVersion namekey=view.relatedcolumn namekeyargkey.0=documentVersion namekeyargkey.1=documentID querysort=documentVersion:document:project:name textmode=true valuefield=documentVersion:document:project:name valueformat=HTML

 

If this column works on your side, you will see that the journal entry is only being stored on the Document Version. This means that in order to reference or filter for anything, you need to start there. So you can see that from the doc version, I was only able to reference the document. From there I had to use the document to reference the project, before being able to finally access the project name. Does this make sense so far?

Terms & ConditionsAccessibility statement

Loading footer...