Use Case Description:

In business applications built with Pega and utilizing the Constellation UI architecture, users often need to view a consolidated list of cases (Work objects) along with their current assignments. This means combining data from both the Work table (which stores general case data) and the Assign-Workbasket or Assign-WorkList tables (which store assignment-specific data, such as to whom and where the case is assigned). Presenting this unified information enables users to quickly assess case status, workload, and take necessary actions.

Challenge:

The pxPages has limitations within the Constellation UI framework. This restricts the ability to configure a view with Work and Assignment tables. As a result, there is a need for an alternative way to combine and display relevant case and assignment data.

Proposed Solution:

Approach 1:

Step 1: Create an association rule Assign-WorkBasket and Work table 

Step 2: Configure the necessary properties in the Report Definition (as shown  in the screenshot below)

Step 3: Configure the authoring in the View to display properties from both the Work table and the Assign-WorkBasket. 

Apporach 2:

To address this limitation in Constellation, the alternative approach is to use Response Data Transforms,

Step 1: Start by creating a report definition in the Assign-WorkBasket class. In this report, set up a join with the Work table. This configuration enables you to fetch relevant fields from both tables in a consolidated report, as demonstrated in the screenshot provided.

Step 2: After the report is set up, create a data page that uses this report definition as its data source. The data page acts as a channel to retrieve and structure the combined data, making it accessible throughout your application. At this stage, you should also create a Response Data Transform, which will process the data once it is retrieved.

Step 3: Within the Response Data Transform, carefully map the properties pulled from the joined report to the corresponding properties in your application. This ensures that data from both the Assign-WorkBasket and Work tables is accurately assigned and readily available for display in the user interface. Visual guidance for this mapping is available in the screenshot below.

Step 4: Proceed to create a landing page in your application, and configure it to use the Data Page you have just set up. This landing page will serve as the main interface where users can view the consolidated information.

Step 5: Finally, configure the columns on the landing page to display the specific fields and data points that are most relevant for your users. This customization helps ensure that the information is presented in a clear and user-friendly manner.

By implementing these steps, you can successfully display integrated data from multiple tables within Constellation, thereby delivering a comprehensive view to users even in scenarios where pxPages functionality is unavailable. This approach not only addresses current limitations but also enhances the overall user experience by making all necessary information accessible in one place.