Clarity: Resource Weekly Detail Portlet does not sort Available Start or Available Finish dates as expected

Document ID : KB000050181
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

We added the 'Available Start' and 'Available Finish' dates to the Resource Planning Allocations Weekly Detail portlet (projmgr.weeklyDetail). When we sort on either column, the data is not sorted.

Steps to Reproduce:

  1. Login to Clarity

  2. Main Application > Resource Planning > Allocations : Weekly Detail Portlet

  3. [--Actions--] Configure > List Column Section: Layout > Add 'Avail Start' and 'Avail Finish' attributes to the layout

  4. Click 'Save and Exit' button

  5. Click column header for 'Avail Finish' to sort data in ascending order (repeat for descending order)

    Figure 1

  6. Click column header for 'Avail Start' to sort data in ascending order (repeat for descending order)

    Figure 2

  7. Configure Multi-sort and view sorting results

Expected Result: The rows should sort according to the dates listed in the portlet for the column being sorted.

Actual Result: The rows appear not to be sorted correctly.

Solution:

The Weekly Detail portlet uses the 'Team Allocations' data provider. The query for this data provider is sorting on the dates that are stored on the Investment > Team: Staff Properties page. When the Staff Member Properties page does not have specific dates, the portlet will use the Investment Start and Finish dates for the 'Avail Start' and 'Avail Finish' columns. However, when the sorting function is invoked, it is only looking at the values for the Staff Member Properties values which can have NULL values. When you sort the column in ascending order, the rows with NULL values on the Team: Staff Properties page will appear at the end of the list. When you sort the column in descending order, the rows with NULL values on the Staff Member Properties page will appear at the beginning of the list.

In the example shown above for Step #6, the 'Avail Start' column is sorted in ascending order.

It appears that the row for 'User, Resource2' with a 'Avail Start' date for 1/1/09 is out of order.

Click on the 'properties' icon (first icon in the list) to see the Staff Member Properties page. The 'Start Date' and 'Finish Date' fields are empty

Figure 3

Entering specific dates in these fields will impact the Investment allocations. If specific dates are entered here, any changes made to the Investment Start and Finish Dates will not automatically update the Staff Member Properties.

STATUS/RESOLUTION:

Resolved in Clarity 12.1.3
Resolved in Clarity 13.0.1, 13.1.0

Keywords: CLARITYKB, CLRT-62531, clarity12resolved, clarity1213resolved, clarity13resolved, clarity1301resolved, clarity1310resolved.