Question
NTT Data Italia S.p.A.
IT
Last activity: 11 Apr 2022 9:27 EDT
Report shows "Partial results shown. Some results cannot be included since data is not optimized."
Hi,
I have a report on one table (work), one filter condition on pyStatusWork (is equal) and one Column Source on custom optimized property. When I launch report system shows message :
"Partial results shown. Some results cannot be included since data is not optimized."
If in the column source I replace custom propery with OOTB property the message disappears.
Why?
Accepted Solution
Updated: 11 Apr 2022 9:27 EDT
Pegasystems Inc.
DE
@StefanoCimmino This message appears if the column population was not done after optimizing the property. As a result the DB column for this property will only be populated for instances that have been saved after the property was optimized and will be empty for all instances saved before that. The message tells you that there might be data in the results that it cannot show because it is not present in the DB column of the property.
You can run the Column Populator Tool (https://docs-previous.pega.com/system-administration/84/populating-properties-using-column-populator-tool) to resolve this issue.