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
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
