I tried to create a report including PageList while referring to the following URL, but it is not possible.
It says that the Declare index is automatically generated when creating the property, but that behavior does not occur.
Could you tell me in detail the procedure for creating a report that includes a Pagelist?
Pega version:8.6.2
Please help me.
@HiroakiS6393 It’s true, Pega creates declare index automatically when you right click an embeded property and click on “Optimize for reporting”.
It will open a landing page where you will be displayed with all the classes the property is available in inheritance path to choose from. Once that’s done, a background process for column population runs.
You can verify the same if completed from “Designer Studio–>System–>Database–>Column Population Jobs.”
Once that also completed you should be able to retrieve the embeded property values in the report definition.
Thank you for your reply. When I checked “Column Population Jobs”, I could see the properties of the Work class belonging to the previously optimized PegaData DataBase, but not the Data class properties belonging to the CustomerData DataBase.
My PageList was created with the Work class, but the reference class is the Data class, so I’m optimizing the properties of the Data class, so I guess the above result is the result. (The Pagelist property of the Work class did not show the Optimize action)
Does optimization have anything to do with classes and database structures?
My Pega environment is on-premise.
@HiroakiS6393 You need to optimize the property from work class by expanding the data model–>property → pagelist (expand the pagelist which contains the property which needs to be optimized) → the property . Once you are at this level right click on the property and click “Optimize for reporting”.
This will create a declare index in the work class, an index class.
Thank you very much!
I have successfully created a Declare index and a report containing Pagelist using the above method!