ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

When sorting in some portlets, data in the column being sorted on displays duplicate data


Article ID: 6425


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


When sorting in some portlets, such as the Investment Timesheet Summary  portlet, data in the column being sorted on displays duplicate data if the query used in the portlet contains a Group By clause in the underlying query. 

Steps to Reproduce:

1. Create a NSQL query with the following code:

SELECT[email protected],
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:i.code:[email protected],[email protected],
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:i.stage_code:[email protected],
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:i.stage_name:[email protected],
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:i.stage_name:[email protected]
i.code,, i.stage_code, stage_name
FROM inv_investments i
JOIN odf_ca_idea oci ON =
LEFT JOIN cmn_lookups_v l2 ON l2.lookup_type = 'INV_STAGE_TYPE' AND l2.lookup_code = i.stage_code AND l2.language_code = 'en'
WHERE 1 = 1
GROUP BY, i.code,, i.stage_code,
) i
where @[email protected]

2. Then create a grid portlet with that query as the data provider
3. Add all fields to the layout
4. Add portlet to a page
5. Navigate to the portlet and click on any header other than idea_id to sort ascending (Ex idea_name)
6. Click on the same header again to sort descending

Expected Results: The results sorts by the value in descending order

Actual Results: Every row in the column ends up having the same value that you are sorting on


This issue is caused by: CLRT-79985


This issue has been reproduced in 14.3 patch 3 and 4 but is not reproducible in 14.3 base or 14.4.



Resort the data for the column that has the duplicating data in ascending order:

1. Navigate to the portlet with the issue

2. Click on the header row for the column that is duplicating data

This will resort the column in ascending order removing the duplicated data shown.

However, there is no workaround to use descending sort in NSQL portlets.


This issue is no longer reproducible in CA PPM 14.4 and higher.