topic Generate feature report with most recent related record/max value in ArcGIS Survey123 Questions

Generate feature report with most recent related record/max value

JRhodes — Tue, 07 Feb 2023 02:53:11 GMT

I have a feature layer representing electric utility structures, with a related table for inspections. I'm attempting to create a feature report with a record for each structure, along with information about the most recent inspection record in the related table as defined by a date field for the inspection date

I've successfully used the Stats method with max to get the most recent inspection date, but I can't figure out how to call that variable in a where clause to define the values for the other fields coming from the related table.

Any ideas would be much appreciated.

Re: Generate feature report with most recent related record/max value

BarbaraWebster1 — Tue, 07 Feb 2023 19:09:53 GMT

Hi @JRhodes,

You could set the result record count for the inspection repeat to one and order the fields by the inspection date. Then you should still be able to add a where filter if needed. So something like this:

${#inspection_repeat| where:"1=1"|orderByFields:"inspection_date DESC" | resultRecordCount:1}

${inspector} ${defect} ${action}

${/}

- Barbara

Re: Generate feature report with most recent related record/max value

JRhodes — Tue, 07 Feb 2023 20:23:03 GMT

Thanks so much Barbara! I was able to get that to work, but I had to pull the leftmost three columns (parent info) out of the table; otherwise, I got "Failed to parse ${FACILITYID} since FACILITYID cannot be found in the current parsing scope.".

So, I was able to do this:

But I was unable to put it all in a line in a single table, like the example in my post. Is it possible to put the parent info and a single related record in a table row within a single table? I tried putting the open/close parent tags both inside the table and outside the table, and both gave the parsing scope error on the first attribute the template was attempting to pull from the parent table.

Re: Generate feature report with most recent related record/max value

BarbaraWebster1 — Tue, 07 Feb 2023 20:52:45 GMT

Unfortunately I believe there's a limitation that prevents parent and repeat records from being on the same line in a table when exporting multiple parent records, however you can get all the records in the same table by putting the repeat record on a line below the parent record.

Template: