topic Re: Include related data from origin table in survey123 report in ArcGIS Survey123 Questions

Include related data from origin table in survey123 report

StaceyHenk — Fri, 10 Dec 2021 20:30:39 GMT

I have a survey that is used to perform inspections on outfall structures. The setup is a one to many relationship, with one outfall for numerous inspection. I am hoping to use the Survey123 reporting tool, but need to figure out if it's possible to pull information from the parent/origin data (the outfall) to the inspection report.

I attempted to do this following the information in the 'repeats' section of this page https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereporttemplates.htm however this outputs data from ALL of the outfalls, not just the one the inspection pertains to. I figured something like this might work but haven't had luck

${#Outfall} ${if (${ID} == ${Inspection.OutfallID}}) ${LocDesc} ${/} ${/Outfall}

Re: Include related data from origin table in survey123 report

ZhifangWang — Wed, 12 Jan 2022 12:12:23 GMT

Hi @StaceyHenk ,

If you iterate from the child layer,
- ${#inspections}
  Fetch attribute of the parent outfall: ${Outfall.field1}
  ${/}
If you want to iterate all inspections of an outfall
- ${#Outfall}
  (The data context is already a specific outfall)
  ${#inspections}
  This is an inspection of ${Outfall.outfallName} on ${inspectionDate}
  ${/}
  ${/}

Re: Include related data from origin table in survey123 report

StaceyHenk — Wed, 12 Jan 2022 14:11:17 GMT

Thanks for the response! I tested out:

${#Outfall} ${Outfall.LOCDESC} ${/}

It returns the LOCDESC of all outfalls in the parent feature class, not just the LOCDESC of the current report. Is there something I need to add so that it only grabs the LOCDESC of the active GlobalID or ObjectID?

Re: Include related data from origin table in survey123 report

StaceyHenk — Wed, 12 Jan 2022 14:13:10 GMT

I also tried:

${#Inspection} ${Outfall.LOCDESC} ${/}

and received an error:

Error: An error occurred when checking the report template. Failed to parse ${Outfall.LOCDESC} since LOCDESC cannot be found in the current parsing scope.

Re: Include related data from origin table in survey123 report

JJ_Reyes — Thu, 20 Jul 2023 17:46:16 GMT

@StaceyHenk - Did you ever get this working?