Skip to main content
Contact a Moderator

Question

2
Replies
1557
Views
 Rajender Reddy Madikanti (RajenderReddyM) Incessant technologies
Incessant technologies
IN
RajenderReddyM Member since 2015 1 post
Incessant technologies
Posted: November 9, 2017
Last activity: November 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.

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 9 Nov 2017 2:07 EST
Nithin Reddy (NithinR4) IGC Instellars
IGC Instellars
IN

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. 

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