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

371
2
09-09-2021 08:06 AM
GrantHoward1
New Contributor II

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

0 Kudos
2 Replies
TL2
by
Occasional Contributor III

date_field = (select max( date_field ) from table)

0 Kudos
GrantHoward1
New Contributor II

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

0 Kudos