Report Definition retrieves property values from DP instead of Database column
Hi, I have a weird behavior when using RD. My scenario is as follows
1. I need to source a table layout with all assignments that a user can open
2. Some values to be shown within the table are saved in dedicated columns of the case's db table
3. These values, in the application, are embedded in a page that is populated using a snapshot pattern (with a connector to an external system as the source)
Now, user opens its dashboard and the table is loaded. My expectation is that RD (with a left join between Assign-Workbasket and Work- classes) retrieves all values from DB only by using the query generated with the RD. However, it seems that when presenting values in the UI, Pega triggers the execution of the Data Page at point (3), causing a huge negative impact on performances.
My question is: is this an expected behavior? Am I missing something that needs to be configured to avoid this?