topic Re: Get latest information from Child table in Dashboards & Analytics Discussions

Get latest information from Child table

babysteps — Wed, 22 May 2024 22:02:59 GMT

We have a scenario where we need to display the latest notes entered.

Parent table:

ID, Amount Due, Due Date

Child table

ID, Parent table ID, creation date, notes entered

We can have multiple child records for a given parent ID. In the listing table we want to display

Parent Table ID, Amount Due, Due Date and notes entered (latest notes i.e. max(creation_date))

How can we achieve this?

Thank you

Re: Get latest information from Child table

RADSr — Thu, 23 May 2024 13:22:36 GMT

I am certain there are multiple ways to get there, but if the most common reporting requirement is to look at the most recent notes I'd create an MV containing *only* the most recent notes. Join that back to the original to provide access to note history via drill through if it's necessary.

That way you'd avoid having authors looking at the incorrect notes accidentally while still enabling full exploration of the detail data.

Any dashboard alternative will require it to be replicated when any new insight/dashboard is created.

HTH