Filter for Date Range?

2678
3
Jump to solution
02-26-2020 07:03 AM
AdamRepsher
Occasional Contributor III

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:

  • Which batteries were installed >=5 years ago - as they would need to be replaced. (Fixed alert-type example)
  • User chooses range of dates to concentrate on when the system was having problems.  (For example:  We collect "Radio Not Working" complaints from our Land Mobile Radio system users.  Our staff must be able to see what complaints happened during a date range so they can evaluate the complaints against things like system outages.  This would help to properly categorize the complaints as NOT user-training, coverage, interference, or end-user hardware problems and quickly close the complaint.

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

1 Solution

Accepted Solutions
TonghuiMing
Esri Regular Contributor

The feature of filtering by date range has been added for AGOL 8.2 release (July 2020).

View solution in original post

3 Replies
TonghuiMing
Esri Regular Contributor

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 

KrisKarki
New Contributor II

Hi Tonghui, I am attempting the date filter as follows: 

KrisKarki_0-1678224562156.png

how to achieve this? Appreciate any guidance.  

Tags (1)
0 Kudos
TonghuiMing
Esri Regular Contributor

The feature of filtering by date range has been added for AGOL 8.2 release (July 2020).