cancel
Showing results for 
Search instead for 
Did you mean: 

Get latest information from Child table

babysteps
Rocketeer

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

1 REPLY 1

RADSr
Captain
Captain

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

-- IncortaOne@PMsquare.com --