Finding Reports That Reference a Specific Custom Field
How do you identify reports impacted by a field change?
As I work to modernize our decade-old Workfront instance in preparation for Planning, Fusion, and future AI capabilities, I'm finding it increasingly difficult to identify which reports are impacted when a custom field is updated, consolidated, or retired.
We currently have more than 700 reports, and I haven't found an efficient way to identify which reports reference a specific field.
For example, we recently consolidated several legacy Yes/No fields into a single multi-select field. The new design is cleaner and easier to maintain, but now I need to identify all reports that:
-
Filter on any of the retired Yes/No fields
-
Display those fields as columns
-
Group by those fields
-
Use those fields in chart configurations
-
Include them in prompts or other reporting logic
Today, the only approach I know of is manually reviewing reports, which is not realistic at this scale.
Questions for the community:
-
Is there a way to report on report definitions and identify reports that reference a particular custom field?
-
Has anyone found a reliable API, text-mode, or Fusion-based solution for impact analysis when changing or retiring fields?
-
How are other large Workfront instances managing report dependency tracking and technical debt?
As our environment grows, understanding the impact of a field change before making it feels increasingly important, and I'm curious whether others have developed a scalable approach.