Reporting on Journal Entry - Notes on Field level status changes | Community
Skip to main content
A
Anonymous
February 10, 2017
Question

Reporting on Journal Entry - Notes on Field level status changes

  • February 10, 2017
  • 2 replies
  • 611 views
I want to report on the changes to Project Planned Completion Date. Unfortunately changing that date, and most fields is recorded as a journal entry and doesn't create a note visible in the notes field. The journal entry object is now exposed to the API, and I know this was some discussion of exposing this as a reportable object. I'm not seeing a way to report on these currently. Anyone know a trick? -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6855 site: "https://www.capabilitysource.com" www.capabilitysource.com email: "mailto:melinda.layten@capabilitysource.com" melinda.layten@capabilitysource.com<
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
February 12, 2017
Hi Melinda, Although it is available through the API (as you point out), I don't believe that the Journal object is exposed through the Workfront reporting engine (which hasn't changed in some time, whereas Journal is a relatively recent addition). So, a few ideas: you did the first one all ready, by trying turning on the Update Feeds to "watch" the Project Planned Completion Date, and see if doing so will record the data you need in the Notes object (which is reportable)...but no go consider taking Baselines, then comparing the Baseline value against the current value to detect the difference consider a calculated field that will detect the previous value (so you can contrast when it changes), with a second input field that will let you "force it" to the current value once the time comes Regards, Doug
A
Anonymous
February 12, 2017
Yep those are my usual tricks. I hoped I had missed something. On Sun, Feb 12, 2017, 5:19 PM ....Doug.... Den Hoed < reportingforum@communitylists.workfront.com> wrote: > Hi Melinda, > > Although it is available through the API (as you point out), I don't > believe that the Journal object is exposed through the Workfront reporting > engine (which hasn't changed in some time, whereas Journal is a relatively > recent addition). > > So, a few ideas: > > - you did the first one all ready, by trying turning on the Update > Feeds to "watch" the Project Planned Completion Date, and see if doing so > will record the data you need in the Notes object (which is > reportable)...but no go > - consider taking Baselines, then comparing the Baseline value against > the current value to detect the difference > - consider a calculated field that will detect the previous value (so > you can contrast when it changes), with a second input field that will let > you "force it" to the current value once the time comes > > Regards, > > Doug > > -----End Original Message----- >
Terms & ConditionsAccessibility statement

Loading footer...