Not all the rows from the Portlet are exported to Excel

book

Article ID: 220849

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

A portlet might be displaying around 10K rows, but many of those are missing when doing an Export to Excel.

The governor limits for export to excel are checked and set at 100K rows.

Cause

The query behind the portlet was returning duplicates.

Those duplicates were not being exported to Excel.

Environment

Clarity PPM 15.x

Resolution

The solution on this case was to fix/tune the query behind the portlet to avoid the duplicates.

 

Additional Information

See additional information/KBs related to this topic:

Export to Excel (Data Only) only exports the first 25,000 rows

Rows getting truncated when exporting to Excel from multi-dimensional portlets