Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Report Editor: Drag&Drop "property does not exist/unoptimized"



When trying to drag and drop an unoptimized property getting an error.

Error Messages

Error 1:
ValidatePropertyName 'IsNotAValidField'

Error 2:
"HandOverToOperationsDate" this property does not exist or has no column mapping
body:""pySQLFunction: ** An invalid column has been entered as a parameter in [Date Value] for a calculation: pxDay. The column does not exist, or is optimised."

Steps to Reproduce

  1. When creating a new report for the AGCS-LI-Work-AltQuote class, all the properties defined in this work class and in all the classes mentioned in the inheritance can be found through the search.
  2. But for the embedded page (pagelist, pagegroup) properties there is an issue.
  3. For example, as shown below, I have a page property .EMailPage of class AGCS-Data-Email in the parent class of AGCS-LI-Work-AltQuote class. Then for this page property I can only see in the Report Editor the properties created directly in the AGCS-Data-Email class. So no inherited properties of AGCS-Data-Email class are available.
  4. Observe: drag and drop an unoptimized property gets an error.

Root Cause

Since the report definition was not saved it was still referring the context of pyDefaultReport. So, it is not able to validate the properties.


There are two solutions for this issue:
  1. The user has to save as pyDefaultReport in Work- Class to their application ruleset and has to enable "Display Unoptimized Properties" in data access tab to display unoptimized properties in data explorer of the report editor.
  2. The user can also first save the report and then again open the same report from report browser and then drag and drop the property.

Published April 7, 2017 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us