When a user creates a report and then later has a user name change (for example, they have gotten a new primary email address and a new username/login), reports do not display correctly under the My Reports section.

Steps to Reproduce

  1. Log in to the instance.

  2. Impersonate a user (for example, Fred Luddy).

  3. Create two new reports under this user's name.

    Note that the reports appear under My Reports in the report_home section.

  4. Amend the username (for example, change the name to Fred Luddy-Now).

  5. Log out and log back in for the change to take effect.

    Check My Reports and note that the two reports do not show (there is no match between [sys_user] and [sys_report] tables).

  6. Create a new report.

    Note that the new report shows correctly under My Reports because the created_by value in the [sys_report] table matches the username in the [sys_user] table.


Note: If you have thousands of records in the [sys_report] table where the username has been changed, then this workaround is not advisable.

Manually edit the Created By field in the [sys_report] table with the new value of the username. This needs to be performed by an Admin user as it requires a temporary base system change, which should then be reverted back once the update is complete.

To enable list editing on the sys_report table:

  1. Navigate to System UI > List Control.
  2. Search for sys_report.
  3. Open the record and change the List edit type from Disable list editing to Save immediately (cell edit mode).
  4. Navigate to the list view of [sys_report] table and sort or filter by the Created By field.
  5. Replace the old username value with the new username value.
  6. Go back to List Control and set the List edit type value back to Disable list editing for the [sys_report] table.

Related Problem: PRB651917

Seen In

Fuji Patch Hot Fix 1
Fuji Patch 11
Fuji Patch 3
Fuji Patch 6
Fuji Patch 7 Hot Fix 3
Fuji Patch 9 Hot Fix 1

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:34:08