I am attempting to filter for a date range with the sqlexpression Builder, and only see choices based on a single date:
I also see an area where it appears that I can add my own SQL or edit it, but it won't let me edit...:
The ultimate experience would be to allow the selection of a date (or date+time) range to allow for searches like:
If I am not missing a way to make date or date/time range filters, either fixed or user-modified, this is a huge hole in the usability of the entire ArcGIS Experience Builder product.
Please tell me I am missing something and show me the documentation.
Thank you,
--Adam
Solved! Go to Solution.
The feature of filtering by date range has been added for AGOL 8.2 release (July 2020).
Hi Adam, thank you for your valuable feedback. To answer your questions:
1. We have not supported the date range in this release. It will be supported together with several other logical operators in the next releases;
2. The area showing the SQL is for display and output only - it does not allow users to edit the actual SQL. If editing the content is desired, you can go back to the SQL expression builder and make changes in the corresponding clause.
The documentation site including the overview, general operations, and widgets can be found here: What is ArcGIS Experience Builder?—ArcGIS Experience Builder Help | Documentation
Hi Tonghui, I am attempting the date filter as follows:
how to achieve this? Appreciate any guidance.
The feature of filtering by date range has been added for AGOL 8.2 release (July 2020).