Because of the date formats, different results are shown in a drill-down of multilevel pivot and heatmap type report on the resource_allocation table.


Steps to Reproduce

  1. Navigate to Plugins in left navigation and activate 'Project Portfolio Suite with Financials' along with demo data
  2. Go to Reports >Create New
  3. Switch to the old UI
  4. Select table 'resource_allocation' and type: multilevel pivot
  5. Columns: Start date
  6. Rows: Resource.Name, Resource plan.Task, Resource plan.Task.Short description
  7. Add the following filter conditions (using AND).
             - Resource plan.State-is one of-Requested, Allocated
             - Start date-at or before-Today
  8. Click a number from the results. You will be able to see the resource plan records.
  9. Open 'glide.sys.date_format' property and change the format to MM-dd-yyyy.
  10. Run the report and click on a value from the resulting multilevel pivot. Observe no records are displayed. On changing date format, records are missing in the drill-down of the multilevel pivot report on the resource_allocation table.


This problem was fixed since Jakarta Patch 9. On earlier releases, as a work around, use System Date format (yyyy-MM-dd) instead of current user's format (MM-dd-yyyy). This allows to drill down the report without issues.


Related Problem: PRB1244424

Seen In

Eureka Patch 11 Hot Fix 2
Fuji Patch 12 Hot Fix 1
Fuji Patch 7 Hot Fix 5

Fixed In

Jakarta Patch 9
Kingston Patch 5

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:40:57