Salesforce-Indicators icon indicating copy to clipboard operation
Salesforce-Indicators copied to clipboard

Functionality to show Indicators based on Child related records

Open tschug opened this issue 1 year ago • 2 comments

Currently, we are using the getRecord and getFieldValue from lightning/uiRecordApi to retrieve the current record's field data (including parent records).

Today, for child records, the recommendation is to leverage rollup summaries and DLRS to display aggregate values as Indicators.

Maybe we consider an additional feature to leverage the getRelatedListRecordsBatch or getRelatedListRecords to easily grab the child records (only one level deep is likely the most manageable). We could then iterate through those and display indicators as well?

I think we need to build up a solid use-case to warrant the effort, but things that come to mind are:

  • Has ever a Contact ever attended a certain event?
  • Does an Opportunity contain a certain product?

tschug avatar Dec 10 '22 01:12 tschug

Oh I love the idea. But yes it's a fair bit of work. I have some other ideas too that I need to write up after using it for real.

JodieM avatar Dec 10 '22 03:12 JodieM

We may explore to use APEX SOQL aggregate queries script and build extension process for it.

nzgonjanin avatar Mar 29 '23 14:03 nzgonjanin