I am working on an app on Pega 24.1.1 using Constellation UI. I used a data page sourced by a report definition for a table with embedded data and got the same issue mentioned in this post:
I realized that using Insights would give me the Filter option for the embedded data, but the issue now is that the behind-the-scenes filters I apply for the table also show on the UI for the users to see, and that makes their filtering process cumbersome. See screenshots below:
Filtering is showing what you’ve filtered - so from this perspective its accurate. If you allowed the user to change filters, then they need to understand the complexity behind those changes (but agree it is complex).
The only way you can hide this, that I am aware, is to build your own Data Page to use for Explore Data / Insights.
You would do the filtering in the data page definition (hidden from the user and Insights)
Data page would have to have Allow querying any column (Pega connection only) checkbox unchecked (not queryable)
Then in Explore Data (from App Studio / Design Time version), you can run Insights directly on data pages.
They do have some limitations on them, as they are not queryable, but that would hide the filters you applied from users.
Thank you for your response. The thing is that we do want to give the users the ability to filter, not to hide it. However, we want the filter to be the simple form without all the behind-the-scenes filter logics. Also, doing it the way you suggested does not give the table all the columns from the embedded data as below:
The table I am currently using has the Activity List’s fields.
I don’t believe this is possible. Like a lot of other Pega features, once you go advanced you can’t go back without undoing advanced (when rules, declare expressions, dynamic texts).
