On pyWorkPage, we have nested page structures such as Page1.Page2.PropertyName, and this data needs to be displayed in Insights.
I attempted to retrieve the column from the Report Definition (which serves as the source for the Insight), but the values are not being fetched in the UI at runtime. I also tried mapping the values using a Response Mapping Data Transform to a flattened property on the source Data Page, but this approach also failed to retrieve the nested page property values during runtime.
Additionally, I tried using a Declare Expression for a one-level page property within the Response Data Transform, but that also did not work.
In this case, the properties involved are of Single Page property, and their corresponding classes are abstract, so optimization is not feasible.
Could you please suggest an alternative approach to handle this scenario?
To achieve this in constellation you need to use Association join in report definition. Create an association linking your current class to the definition of the first nested page, and then create a nested association that points to the second-level page.
Hi @Anoop_Krishna, Thank you for the reply. Here the Single Page property has classes which are of Abstract type. We cannot create associate joins for those classes in Report definition.
When you try this, did you uncheck the checkbox “Allow querying” in the data page? Because, when that checkbox is checked, your response data transform will not run. You need to uncheck it and when creating the insight, select that data page and then your flattening logic will work.
When unchecking the Allow Querying checkbox from datapage we are able to fetch the records for nested pages from report but we are losing the insights capabilities like promoted filters and export to excel. We need both insight features to be supported along with nested page records.
