# How to display an indicator for related Data records in a Constellation List View **URL:** \ **Category:** User Experience\ **Tags:** user-experience\ **Created:** [September 28, 2026, 2:11am UTC](https://forums.pega.com/t/how-to-display-an-indicator-for-related-data-records-in-a-constellation-list-view/13597 "2026-09-28T02:11:08Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![YasuhiroI17812719](https://avatars.discourse-cdn.com/v4/letter/y/c57346/32.png) [@YasuhiroI17812719](https://forums.pega.com/u/YasuhiroI17812719)\ **Post date:** [September 28, 2026, 2:11am UTC](https://forums.pega.com/t/how-to-display-an-indicator-for-related-data-records-in-a-constellation-list-view/13597/1 "2026-09-28T02:11:08Z")
I have a Constellation List View or Insight that displays records from `ABC-DEF-Work`. For each Case ID in the list, I want to determine whether `ABC-DEF-Data-NNN` contains one or more rows with the same Case ID. The requirement is only to display the result in the list, for example: - Matching record exists → icon, mark, or `true` - No matching record → blank or `false` I do not need to display the related records themselves. I only need an indication of whether at least one related record exists. I have tried the following approaches: 1. **Query-type property (impossible)** I considered using a Query-type property, but it did not appear as an available field when configuring the List View, so I could not achieve the expected result. 2. **Data Transform (no good)** I considered setting a specific property to `true` using a Data Transform when related data exists. However, I could not determine the appropriate timing to load and set this value, or how to keep it updated when the related Data records are updated. 3. **Association rule (does not meet requirement)** I also tried joining `ABC-DEF-Work` and `ABC-DEF-Data-NNN` using an Association rule. However, when multiple matching Data records exist for the same Case ID, multiple rows are listed. This does not meet the requirement because I need only one row per Case ID with an indication of whether matching Data exists. Is there a supported way to achieve this in a Constellation View or Insight? Thank you for your comments. ---
**Author:** ![VVNagaSaiN](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/vvnagasain/32/23160_2.png) [@VVNagaSaiN](https://forums.pega.com/u/VVNagaSaiN)\ **Post date:** [September 28, 2026, 11:30am UTC](https://forums.pega.com/t/how-to-display-an-indicator-for-related-data-records-in-a-constellation-list-view/13597/2 "2026-09-28T11:30:45Z")
Hello, Instead of evaluating this dynamically at runtime, we can store a flag directly on the Case record. You can create a boolean property (e.g., `HasRelatedData`) on `ABC-DEF-Work` and expose it as a database column. Whenever a record in `ABC-DEF-Data-NNN` is saved or deleted, trigger a Declare Trigger rule to update the corresponding Work instance. This keeps your Constellation List View or Insight completely out-of-the-box and performant, as you only need to add that scalar property as a column. ---
**Author:** ![RameshSangili](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/rameshsangili/32/22508_2.png) [@RameshSangili](https://forums.pega.com/u/RameshSangili)\ **Post date:** [September 28, 2026, 2:23pm UTC](https://forums.pega.com/t/how-to-display-an-indicator-for-related-data-records-in-a-constellation-list-view/13597/3 "2026-09-28T14:23:03Z")
Yes I agree with @VVNagaSaiN. If that’s not an option, Use Data Page and inturn use the Report definition to write the logic to get it from other Data-NNN using subreport. ---
**Author:** ![YasuhiroI17812719](https://avatars.discourse-cdn.com/v4/letter/y/c57346/32.png) [@YasuhiroI17812719](https://forums.pega.com/u/YasuhiroI17812719)\ **Post date:** [September 29, 2026, 12:58am UTC](https://forums.pega.com/t/how-to-display-an-indicator-for-related-data-records-in-a-constellation-list-view/13597/4 "2026-09-29T00:58:43Z")
Thank you very much for your suggestion. I appreciate the idea of storing the flag directly on the Case. One concern I have with this approach is that `ABC-DEF-Data-NNN` does not have a direct reference to a specific Work instance. Therefore, when a Data-NNN record is saved or deleted, it is not clear how we can determine which Case should have its `HasRelatedData` flag updated. **Would this mean that we would need to define an association from the Data-NNN side back to the Work class in order to identify the corresponding Case?** Could you please clarify how you envision handling this part? Outside of a List View, I was able to achieve the required result using a Data Transform by setting a property based on the resultscount, for example setting it to true when the result count is greater than 0. The difficulty is achieving the same type of result in a List View. Comments would be much appreciated. ---
**Author:** ![YasuhiroI17812719](https://avatars.discourse-cdn.com/v4/letter/y/c57346/32.png) [@YasuhiroI17812719](https://forums.pega.com/u/YasuhiroI17812719)\ **Post date:** [September 29, 2026, 1:01am UTC](https://forums.pega.com/t/how-to-display-an-indicator-for-related-data-records-in-a-constellation-list-view/13597/5 "2026-09-29T01:01:47Z")
Thanks, but I wonder some point regarding subreport. Let me know how it would be archived at Constellation UI? ---
**Author:** ![YasuhiroI17812719](https://avatars.discourse-cdn.com/v4/letter/y/c57346/32.png) [@YasuhiroI17812719](https://forums.pega.com/u/YasuhiroI17812719)\ **Post date:** [September 29, 2026, 12:55pm UTC](https://forums.pega.com/t/how-to-display-an-indicator-for-related-data-records-in-a-constellation-list-view/13597/6 "2026-09-29T12:55:01Z")
I have got the solution. It requires appropriate setting and time passing (1-2 hours) to complete affection to List view fields update. Step1. Create query type property ( NotifyCountCase). ![image](https://pega1.discourse-cdn.com/pega/original/3X/6/e/6e91a0e085d1eb1f889129ff597ae19c35c81477.png) ![image](https://pega1.discourse-cdn.com/pega/original/3X/c/6/c62a0df372f2f8b2cca8b7fe5cc40b16dcc384a8.png) It refers Single Page (DataPage). ![image](https://pega1.discourse-cdn.com/pega/original/3X/3/8/38103a13a509ad92da3edf34e4bc99ce3495e31b.png) Data transform , just count caseID on the other table (custom notice table). The case id is single clue of the Data-NNN table (there is no refereced object key nor else). ![image](https://pega1.discourse-cdn.com/pega/original/3X/8/b/8bb0faed563d8526ac6de4e0dee289c667ca1132.png) Datasource.pxResultCount returns the number of instances of the caseIDs. As the result I could see the List view. ![image](https://pega1.discourse-cdn.com/pega/original/3X/d/2/d2a3de6365aef4c466d7b964f66363e89d256dd7.png) The problem was taking time to find the candidate column. (Constellation update) ![image](https://pega1.discourse-cdn.com/pega/original/3X/4/3/43fe1bd6d226da43986db25d1b493e69de233339.png) ![image](https://pega1.discourse-cdn.com/pega/original/3X/a/4/a4e675c4605014a34fc2a50aefb37706429c6c7b.png) These CaseCount and Mark field (property), were coming 1 hour later after I set up. Anyway, I could get these on the list. I did not set any trigger but I could get the update data after touching other tab or page. Thanks. ---
**Author:** ![VVNagaSaiN](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/vvnagasain/32/23160_2.png) [@VVNagaSaiN](https://forums.pega.com/u/VVNagaSaiN)\ **Post date:** [September 29, 2026, 12:55pm UTC](https://forums.pega.com/t/how-to-display-an-indicator-for-related-data-records-in-a-constellation-list-view/13597/7 "2026-09-29T12:55:12Z")
> [@YasuhiroI17812719](#): > > For each Case ID in the list, I want to determine whether `ABC-DEF-Data-NNN` contains one or more rows with the same Case ID. In your post, I see you have rows in the data class with a column having case ID. ---
**Author:** ![VVNagaSaiN](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/vvnagasain/32/23160_2.png) [@VVNagaSaiN](https://forums.pega.com/u/VVNagaSaiN)\ **Post date:** [September 29, 2026, 1:00pm UTC](https://forums.pega.com/t/how-to-display-an-indicator-for-related-data-records-in-a-constellation-list-view/13597/8 "2026-09-29T13:00:07Z")
Yeah, it works. But, we are running an additional SQL query for each row to fetch the count. (That means if there are 10 rows, we have 10 SQL queries) For small amount of data, this works fine. If we have huge data, then this starts showing performance issues. ---
**Author:** ![YasuhiroI17812719](https://avatars.discourse-cdn.com/v4/letter/y/c57346/32.png) [@YasuhiroI17812719](https://forums.pega.com/u/YasuhiroI17812719)\ **Post date:** [October 2, 2026, 2:03am UTC](https://forums.pega.com/t/how-to-display-an-indicator-for-related-data-records-in-a-constellation-list-view/13597/9 "2026-10-02T02:03:36Z")
Yeah, exactly. The base List table will have more than 10,000 records, and the joined table will also have thousands of records. I need to **inform the project owner about this performance concern**. Anyway, the functional limitation itself has been proven. Thanks.