Survey123 Report: use a field from a repeat as where clause in different repeat

JamieMaxwell

In a feature report, is it possible to use the value of a field from one repeat in the where clause of a second repeat? The two repeats are direct children of the parent record but are not nested with each other.

That is what I'm trying to do:

${#repeat1}
${#repeat2 | where:"field1inrepeat2=field1inrepeat1"}${field2inrepeat2}${/}
{$/}

 I've tried a bunch of different variations for the where clause, such as where:"field1inrepeat2='"+repeat1.field1inrepeat1+"'" or where:"field1inrepeat2="repeat1.field1inrepeat1"

The goal is to pull a value from a different repeat if the date in the current repeat record matches it.

Any help would be appreciated! I've read through all of the documentation, videos, and a bunch of posts but I can't determine if this is possible or not.

TylerGraham2

The ${#repeat1} ${#repeat2}...${/}${/} only works if they are nested. You need to use $layers to independently call layers in your feature service.  

Documentation for $layers is excellent, consisting of 1 entire sentence.  

https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereport-expressions.htm#:~:text=%24layers%5B%22%3Clayername%3E%22%5D%20or,%24layers%5B%3ClayerId%3E%5D

You might try combing the repeat and $layers into something like:

${#repeat2 | where:"fieldrepeat2= '" + ${$layers["repeat1name"] | where:"1=1" | outFields:"repeat1date"} + "'"} 

and see what happens.

I'd test the $layers independently to get it working before you try passing it into something. I have found it to be very finicky to get anything working with it.