Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Rajender Reddy Madikanti (RajenderReddyM)
Incessant technologies

Incessant technologies
GB
RajenderReddyM Member since 2015 1 post
Incessant technologies
Posted: Nov 9, 2017
Last activity: Nov 13, 2017
Posted: 9 Nov 2017 1:23 EST
Last activity: 13 Nov 2017 1:33 EST
Closed

Report definition not saving Declarative Index Join

As part of the Reporting exercise I'm trying to add the generated Index_EmployeeDetails to my Report Definition rule (see screenshot). However, when I press the Save button after successfully pointing to this Declarative Index Join, the table row with the definition suddenly disappears from the Data Access tab.

To see attachments, please log in.
Reporting

  • Rupesh Gali
Posted: 7 years ago
Posted: 9 Nov 2017 2:07 EST
Nithin Reddy (NithinReddyNoothula)
Evonsys
Senior consultant
Evonsys
NL

Hi Rajender,

  Generally Reports will remove the index if it is not actually used anywhere in the our report on save.  It does this because, as an optimization to prevent unnecessarily slowing  the SQL(Its like pre condition if we are using that declare index values then only it will joins the declare index class and forms the SQL.). If we use anywhere in our report like filter or in query it will not get removed.I hope it is clear. 

To see attachments, please log in.

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

Pega Collaboration Center 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