Prerequisites
Before you can perform the actions described in this article, you must make sure of the following:
-
Any fields (including custom fields) that you want to report on are tracked in Workfront. You can only report on data from the Updates area that is tracked.
To learn how to add fields that you want Workfront to track, see Configure system updates.
Journal Entry report overview
Because the Journal Entry report queries system updates, it can return a significant number of results. For this reason, we recommend that you filter to specific objects—such as projects, programs, portfolios, groups, and so forth—when creating the report.
To learn more about the different object types in Workfront, see Understand objects in Adobe Workfront.
The default view for this report contains the following columns:
Field | Explanation |
---|---|
Field Name |
The name of the affected field. Depending on how you set up the report, this column could contain Status, Owner ID, Task Name, Planned Completion Date, or other fields. When DE: displays in this column, it indicates that the field listed is a custom field. |
Change Type |
The type of change made to the affected field. Depending on the filter rules that you set up and the actions taken by users, the following might appear in this field:
|
Top ObjCode | The highest parent object in the hierarchy. |
Scope | The type of object that was changed. |
Entry Date | The date that the field was changed. |
Edited by Name | The user that changed the field. |
To organize the information in this report, you can use the built-in grouping called Project. The Project grouping gives you a primary grouping of Project Name and a secondary grouping of Entry Date. You can apply this existing grouping during report creation, or you can apply it when viewing the report.
To learn how to set up the views, filters, and groupings you want for your report, see the relevant section:
See what status changes occurred
You can set up the Journal Entry report to show:
-
How many status changes were made on a project, task, or issue
-
What the previous status was before the change
-
Who changed the status
-
When the status change took place
If you want to see the health of a project, you could also set up the report to show this same information using the project Condition field.
This information can be used to help with auditing and to illustrate how well you and your organization are planning.
To learn more about Enhanced analytics, see Enhanced analytics overview.
-
Click the Main Menu icon
-
Click New Report, then select Journal Entry.
The report builder loads.
-
In the Columns (View) tab, add the following columns:
Column Explanation Field Name The name of the affected field. In this case, status should display in this column. Change Type The type of change made to the affected field, such as Add, Delete, or Edit. Edited by Name The name of the user that updated the status. Entry Date The date that the status was changed. Old Text Value The key for the previous status. The following are the status keys for the default project statuses:
-
CUR: Current
-
DED: Dead
-
ONH: On Hold
-
PLN: Planning
-
CPL: Complete
-
REQ: Requested
-
APR: Approved
-
REJ: Rejected
-
IDA: Idea
If your organization has set up custom statuses, other status keys might appear in this column. To learn what custom status is related to a status key, contact your Workfront administrator or group administrator.
New Text Value The key for the updated status. Top ObjCode The highest parent object for the field that had the status change. Scope The type of object that had the status change. Issue Name
(Optional)The name of the issue that had a status change. Task Name
(Optional)The name of the task that had a status change. For more information on adding columns, see Views overview in Adobe Workfront.
-
-
In the Filters tab, click Add a Filter Rule, then add the filter rule Field Name > Equal > status.
TIP
To report on condition changes, you can instead add the filter rule Field Name > Equal > Condition.For more information on adding filters, see Filters overview.
-
(Optional) To narrow the focus of the report and reduce load times, add a prompt.
Or
Create additional filter rules to include specific projects, tasks, or issues.
IMPORTANT
Creating a filter rule that uses the modifier Contains can actually increase load times. For this reason, we recommend using a different modifier like Equal when possible to filter for a specific project or higher-level object ID.To learn how to add a prompt, see Add a prompt to a report.
-
In the Groupings tab, click Apply an Existing Grouping, then select Project.
For more information on adding groupings, see Groupings overview in Adobe Workfront.
-
Click Save + Close.
Your new report loads.
See when a task or issue was deleted
You can set up the Journal Entry report to show:
- What tasks or issues have been deleted
- Who deleted a task or issue
To see when a task or issue was deleted:
-
Click the Main Menu icon
-
Click New Report, then select Journal Entry.
The report builder loads.
-
In the Columns (View) tab, add the following columns:
Column Explanation Scope The type of object that was deleted. Change Type The type of change that happened. The Delete change displays in this column. Entry Date The date that the task or issue was deleted. Edited by Name The name of the user that deleted the task or issue. Project Name The name of the project that had tasks or issues deleted. For more information on adding columns, see Views overview in Adobe Workfront.
-
In the Filters tab, click Add filter rule, then add the following filters:
- Change Type > Equal > Delete
- Project ID > Equal > < project name >
For more information on adding filters, see Filters overview.
-
(Optional) To narrow the focus of the report and reduce load times, add a prompt.
Or
Create additional filter rules to include specific projects, tasks, or issues.
IMPORTANT
Creating a filter rule that uses the modifier Contains can actually increase load times. For this reason, we recommend using a different modifier like Equal when possible to filter for a specific project or higher-level object ID.To learn how to add a prompt, see Add a prompt to a report.
-
(Optional) In the Groupings tab, click Apply an Existing Grouping, then select Project.
For more information on adding groupings, see Groupings overview in Adobe Workfront.
-
Click Save + Close.
Your new report loads.
See how custom fields changed over the course of a project’s life cycle
You can track important field changes over the course of the project. To do this, you can set up the Journal Entry to track:
- If certain custom fields were added, updated, or edited
- When these changes happened
- Who made the changes
To see how custom fields changed over the course of a project’s life cycle:
-
Click the Main Menu icon
-
Click New Report, then select Journal Entry.
The report builder loads.
-
In the Columns (View) tab, ensure you have or click Add Column to add the following columns:
Column Explanation Field Name The name of the custom field affected.
When DE: displays in this column, it indicates that the field listed is a custom field.
Change Type The type of change made to the affected field, such as Add, Delete, or Edit. Edited by Name The name of the user that updated the custom field. Entry Date The date that the value in the custom field changed.
You should sort by this field in descending order.
Old Number Value The previous number value in the custom field. New Number Value The current number value in the custom field. Old Date Value The previous date value in the custom field. New Date Value The current date value in the custom field. Old Text Value The previous text value in the custom field. New Text Value The current text value in the custom field.
If the custom field is a typeahead field, the New Text Value column displays the object ID.
For more information on adding columns, see Views overview in Adobe Workfront.
-
In the Filters tab, click Add a Filter Rule, then add the following filters:
-
Journal Entry Field Name > Contains > DE
TIP
To limit this report to specific custom fields, add the filter rule Journal Entry Field Name > Equal > < custom field name>. -
Project ID > Equal > < project >.
For more information on adding filters, see Filters overview.
-
-
(Optional) To narrow the focus of the report and reduce load times, add a prompt.
Or
Create additional filter rules to include specific projects, tasks, or issues.
IMPORTANT
Creating a filter rule that uses the modifier Contains can actually increase load times. For this reason, we recommend using a different modifier like Equal when possible to filter for a specific project or higher-level object ID.To learn how to add a prompt, see Add a prompt to a report.
-
In the Groupings tab, click Apply an Existing Grouping, then select Project.
For more information on adding groupings, see Groupings overview in Adobe Workfront.
-
Click Save + Close.
Your new report loads.
See how the Planned Completion Date changed over the course of a project’s life cycle
You can set up the Journal Entry report to show how often the Planned Completion Date changes over the course of a project’s life.
-
Click the Main Menu icon
-
Click New Report, then select Journal Entry.
The report builder loads.
-
In the Columns (View) tab, add the following columns:
Column Explanation Field Name The name of the affected field.
When DE: displays in this column, it indicates that the field listed is a custom field.
Change Type The type of change that happened, such as Add, Delete, or Edit. Edited by Name The name of the user that updated the project's Planned Completion Date. Entry Date The date that the project's Planned Completion Date was changed.
You should sort by this field in descending order.
Top ObjCode The highest parent object for the field that had the Planned Completion Date change. Scope The object that had the Planned Completion Date change. Old Date Value The previous value for the Planned Completion Date. New Date Value The current value for the Planned Completion Date. Project Name
(Optional)
Thhe name of the project that had the Planned Completion Date change. Task Name
(Optional)
The name of the tasks in the project that had the Planned Completion Date change. Issue Name
(Optional)
The name of the issues in the project that have the Planned Completion Date change. For more information on adding columns, see Views overview in Adobe Workfront.
-
In the Filters tab, click Add a Filter Rule, then add the following:
- Field Name > Equal > Date
- Project ID > Equal > < project name >.
For more information on adding filters, see Filters overview.
-
(Optional) To narrow the focus of the report and reduce load times, add a prompt.
Or
Create additional filter rules to include specific projects, tasks, or issues.
IMPORTANT
Creating a filter rule that uses the modifier Contains can actually increase load times. For this reason, we recommend using a different modifier like Equal when possible to filter for a specific project or higher-level object ID.To learn how to add a prompt, see Add a prompt to a report.
-
In the Groupings tab, click Apply an Existing Grouping, then select Project.
For more information on adding groupings, see Groupings overview in Adobe Workfront.
-
Click Save + Close.
Your new report loads.
See if the owner of a project changed
You can set up the Journal Entry report to show how many times the project owner—or project manager—changes over the course of a project’s life.
-
Click the Main Menu icon
-
Click New Report, then select Journal Entry.
The report builder loads.
-
In the Columns (View) tab, add the following columns:
Column Explanation Field Name The name of the affected field. The ownerID displays in this column. Change Type The type of change that happened, such as Add, Delete, or Edit. Top ObjCode The highest parent object for the project that had the project owner updated. Entry Date The date that the project owner was changed.
You should sort by this field in descending order.Edited by Name The name of the user that updated the project owner. Additional Info 1 The current project owner on the project. Additional Info 2 The previous project owner on the project. Project Name The project that had the Project Owner field updated. For more information on adding columns, see Views overview in Adobe Workfront.
-
In the Filters tab, click Add filter rule, then add the following:
- Field Name > Equal > ownerID
- Project ID > Equal > < project name >.
For more information on adding filters, see Filters overview.
-
(Optional) To narrow the focus of the report and reduce load times, add a prompt.
Or
Create additional filter rules to include specific projects, tasks, or issues.
IMPORTANT
Creating a filter rule that uses the modifier Contains can actually increase load times. For this reason, we recommend using a different modifier like Equal when possible to filter for a specific project or higher-level object ID.To learn how to add a prompt, see Add a prompt to a report.
-
(Optional) In the Groupings tab, click Apply an Existing Grouping, then select Project.
For more information on adding groupings, see Groupings overview in Adobe Workfront.
-
Click Save + Close.
The new journal entry report displays.
More help on this topic
Workfront
- Workfront documentation
- Product announcements
- Administration and setup
- Adobe Workfront basics
- Agile
- Documents
- Manage Work
- Teams and groups
- Reporting
- Manage resources
- Review and approve work
- Timesheets
- Adobe Workfront Scenario Planner
- Adobe Workfront Goals
- Adobe Workfront Planning
- Adobe Workfront Integrations
- Workfront Proof
- Adobe Workfront API
- ProofHQ API
Learn: Automating Workflows with Workfront Fusion - Unique Use Cases in Action
Workfront
Tuesday, Mar 4, 6:00 PM UTC
Looking for creative ways to use Workfront Fusion to solve business challenges? Join Pan Shahbazian of Starbucks as she shares three unique use cases that can transform your workflows.
RegisterThe Perfect Blend: A New Era of Collaboration with AEM and Workfront
Adobe Customer Success Webinars
Wednesday, Apr 2, 5:00 PM UTC
Explore how Adobe Experience Manager and Workfront integrate to help teams move from ideation to delivery without the usual bottlenecks, ensuring content is organized, on-brand, and ready to go live faster.
RegisterAdobe Workfront at Summit
Register for these user sessions:
- Driving Marketing Agility and Scale: Transforming your Content Supply Chain with AI (attend online)
- Adobe’s Top 10 Generative AI Capabilities to Accelerate Your Content Supply Chain (attend online)
- A Proven Framework to Boost Campaign Creation Speed (attend online)
- How Workfront Is Bringing Enterprise-Ready AI to Work Management (attend online)
- The Future of Adobe Workfront (attend online)
Connect with Experience League at Summit!
Get front-row access to top sessions, hands-on activities, and networking—wherever you are!
Learn moreRegister to learn something new
WORKFRONT
Join Adobe product experts in live events where you will learn Adobe Workfront best practices, tips and tricks, and hear about the latest product features and updates.
Register