Timesheet Entry Notes missing in report designer

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Text in the 'Note' of 'Time Entry Notes' column from out of the box data provider 'Time Entry and Timesheet Notes' does not display
when a user does a Group By on Task Name in a Report Designer

 

Steps To Reproduce:

1. Create two projects and allocate labour resource then assign to a task on each of the projects..
2. Post a couple of timesheets for the resource on each of the task
3. Run Load Data Warehouse (full load) 
4. Make a copy of the out of the box data provider 'Timesheet Entry Notes' then add the following columns; 
   'Time Period', 'Posted Time', 'Time Entry Notes.Note', 'Time Entry.Task', 'Time Entry.Investment', 'Timesheet.Resource', 'Per-Period Metrics. Actuals'
5. Using Report designer, create a new report using data provider from step 4 above and add a table widget. Include all the columns added from step 4
6. Proceed to publish report. Data displays okay together with the Timesheet Note.
7. Edit Report designer then do a Group By on Task Name then publish.

 

Expected: Report Designer to display Time Entry Note text

Actual: Report Designer does not display Time Entry Note text when a Group By is done on Task Name

Environment

Clarity 16.3.3

Cause

DE177574

Resolution

This has been determined not to be a defect.

The 'note' attribute is of type clob. If you are enabling the toggle 'Auto Expand Groups' in the 'Format' tab, we call it 'groupBy expandAll'. 
The 'groupBy expandAll' doesn't support clob type due to technical limitation. Because of this, these are restricted and this is by design.

In addition to this, there are a few other data types that come under this category. i.e. we won't see the data for the attributes of following types, 
when 'Auto Expand Groups' toggle is enabled.

CLOB, ATTACHMENT, RICH_TEXT, MULTIVALUED etc.

Note: If the said toggle is not enabled, then it will display the data correctly.