My report shows annual test results for different locations. Test results are stored in a relationship table. I want the report to only show the last 2 years' tests. I have attached a copy of the report after being created by Survey123 and a copy of the document used to create the form.
In your report template, try replacing
${#BACKFLOWTESTRESULTS}
with
${#BACKFLOWTESTRESULTS | where: "TESTDATE BETWEEN CURRENT_TIMESTAMP - 730 AND CURRENT_TIMESTAMP" | orderByFields:" TESTDATE DESC"}
More on this here: https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereportqueries.htm
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
