How do I show only the latest related table entry on a Survey123 Report?

Question

I have a property inspection feature layer and a related table for the inspection details. Each time an inspection is performed I want to create a report, but I don't want the report to include details of every previous inspection done on the property; I just want to include the details from the latest inspection (related table entry).
Thanks,
Grant

GrantHoward1 · Answer

Thanks for the response TL2. So would I apply this in the syntax on the form template?

Or as a filter on the related table in the web map?

Or I see there is a filter option within the Survey123 page when under the 'Data' tab?

Thanks,

Grant

TLongSUGF · Answer

date_field = (select max( date_field ) from table)