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
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
