Virtual column that displays las updated row of child table

I have a table shipments and shipment_stat_reports that has a column “status” and “timestamp” at the time of the report. I want to build a virtual column that displays the last status of the shipment based on the most recent update but I don’t know how. I’ve tried with filter and select but no success

Hi @Rene_Casana
Maybe check out MAx and MAXROW

1 Like