idea ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year' in ArcGIS Online Ideas

ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

Amanda__Huber — Tue, 30 Apr 2024 19:33:03 GMT

Hello AGOL Team,

In Map Viewer it appears there is is no filter option for "within the current year". Our organization desperately need this (as I'm sure many others do as well). For some of our production projects we have filters set to the current year, and every year we have to manually go into these web maps and update the year/date in the filter.

Please consider adding a filter for "within the current year".

In addition, please note the difference in variety of filter options between Map Viewer and even ArcGIS Dashboards. Please consider filter equivalency between the two platforms:

Thank you,

Amanda Huber

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

sondickerson — Tue, 30 Apr 2024 21:21:51 GMT

Is it possible to use an arcade expression in your query - and use Year(Now())

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

RussRoberts — Wed, 01 May 2024 01:15:39 GMT

Is this a Date Only field or the classic Date-Time on a hosted feature layer?

We do support this type of relative filtering in Map Viewer with Date-Time and have Date Only support coming in the next update.

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

Amanda__Huber — Wed, 01 May 2024 20:29:43 GMT

Hi @RussRoberts ,

Thanks so much for your response, that's great to hear!

To clarify your definition of "Date Only" and "Date Time"-

I did some digging and we're working with a federated Enterprise service (coming from our SDE). At the SDE level this field is labeled as a "date" field but is "date-time" field.

In the service, the field is defined as a "Date" type also:

If I'm understanding correctly, when you refer to "date-time" that should be referring to the field type that we're using (defined at the SDE level), correct? If so, is there a reason we are unable to see the options you're suggesting we should see?

We've been able to reproduce this behavior across other datasets that are also using SDE "date-time" fields.

Update- Tested this workflow on an AGOL hosted feature layer as well (cut of the data) and we able to see the additional expression options.

Unfortunately "in the last" still isn't quite what we're looking for thought. We're looking for "In the Current" such as current Year, current Month, or Current Day.

Thanks,

Amanda Huber

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

SteveCole — Thu, 02 May 2024 15:16:04 GMT

@Amanda There's an old, open idea for adding support for Arcade based fields inside layer definition queries that you could vote up. This would be one option, if it was supported. You could create an Arcade field that is coded YES/NO based on evaluating your date field against the current year.

Outside of that, there is another option which is a pain in the butt but you can decide if the hassle factor is worth it. Simply put, you can use ArcGIS Assistant to edit the underlying definition query for the layer you're interested in. The SQL that's used does support some date manipulation so it's a matter of finding the right syntax for querying records within the current year.

I had to use this approach in order to add some date filtering to a data layer in one of my maps (that thread is here).

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

Amanda__Huber — Thu, 02 May 2024 15:50:53 GMT

Hi @SteveCole thanks for that info, I'll definitely kudos that arcade post.

That's an interesting workaround. I'm a little hesitant to use AGOL Assistant because it's technically " not supported by Esri" (last I knew), but just to confirm, ArcGIS assistant supports "in the current" as a query? Does the year need to be hard coded or is it dynamic (meaning it will update itself every year)? I'll do more digging to see the sql that you're referring to also.

Looking forward to hearing what Russ has to say too.

Thanks!

Amanda Huber

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

SteveCole — Thu, 02 May 2024 15:57:54 GMT

@Amanda__Huber Yeah, it is unsupported so you'll want to consider that. If it's a "read only" map where you're not enabling users the ability to alter the layer's definition query, it's probably ok.

ArcGIS Assistant doesn't support "in the current" per se- it's simply an editor for the underlying editor for all the JSON that defines a map & it's contents. What will support "in the current" will be the SQL query language of the database that houses the data so that might be Microsoft SQL Server SQL or Oracle's flavor of SQL. That's where you'll need to dig and experiment.

Either way, you will NOT want to tweak this inside of the ESRI Map Viewer once you have it set up (because it doesn't support it within the UI so it might blow it out). Again, you'll need to evaluate if the risk/reward is worth it for your situation.

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

Amanda__Huber — Tue, 14 May 2024 16:38:41 GMT

@RussRoberts any update on this? Thanks!

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

RussRoberts — Wed, 15 May 2024 15:20:26 GMT

Hey @Amanda__Huber We are looking into it. It will be similar to the hosted case posted above with the "In the last" and then you would pick the unit of time similar to the hosted case.

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

RussRoberts — Thu, 27 Jun 2024 20:12:59 GMT

We added support for enterprise services in Map Viewer that will allow relative date filters(In the last, not in the last) on Date and DateOnly fields. This is supported on 10.9.1 and up services. We also added support for specifying the time on the date field for the non relative queries. The expressions like "In the Current x" is not supported.

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

JonasNeubürger — Fri, 23 Aug 2024 09:54:44 GMT

I am currently on ArcGIS Enterprise 11.2 with the latest patches and found this thread, while trying to figure out, why I could not filter a feature layer by date.

The field i am trying to set a filter on, is of type "esriFieldTypeDateOnly" because I have no time information for the features anyways. But I can not even choose this field when building an expression.

@RussRoberts, is this field type - suggested in this specification - not suited for filtering? It seems to work in MapViewer somehow, because I can change the fields date format just fine. Maybe this field type is not quite equal to this specification?

If so, please add a hint to your documentation or a compatibility matrix for datatypes and their respective names in different parts of your documentation. It's really frustrating to not be able to do basic filtering on basic field types.

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

RussRoberts — Mon, 26 Aug 2024 13:30:21 GMT

Date Only support in filtering was added in 11.3 and then with relative filters will be coming in 11.4 enterprise release. We added support for this in ArcGIS Online in the June 2024 release.

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

BrettFrahm — Wed, 02 Apr 2025 14:42:02 GMT

@RussRoberts Can you clarify the current status for this Idea. Here is my understanding below based on your last comment.

Date Time field in Portal/ArcGIS Online -> No support for filtering to current year
Date Only field in Portal 11.3 and ArcGIS Online (including portal features collaborated to AGO) -> Support for filtering to current year

Thank you,

Brett

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

RussRoberts — Wed, 02 Apr 2025 14:58:59 GMT

Support for

Date-Time(classic date field type) relative time filters "in the last year" supported on hosted and non hosted services in AGO.
- Non hosted layers must be
  - Min server version 10.9.1
  - Must have standardized queries enabled
- 11.4 Bringing same support as above. Pre 11.4 was hosted only feature services on the portal.
Date Only relative date filters
- Support added 11.4

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

BrettFrahm — Wed, 02 Apr 2025 15:18:18 GMT

@RussRoberts Thank you for such a quick response. I'd like to point out that this ArcGIS Idea is for being able to filter to current year and not necessarily just support for relative time filters (which are still an amazing addition).

With an 11.2.1 ArcGIS Server feature service in ArcGIS Online (standardize queries enabled) I am only able to do "In the last" and "not in the last" queries for a date-time field, which does not allow me to specifically filter to the current year.

With that I'll assume that this feature is still on the horizon and will wait eagerly for its arrival.

Thank you,

Brett

Re: ArcGIS Online- Map Viewer- Filter Expression option for 'Within the Current Year'

Amanda__Huber — Thu, 03 Jul 2025 16:32:12 GMT

@RussRoberts I just wanted to check in on this now that we've had the June update, we're still not seeing this functionality in Map Viewer for "within the current year". Is there any update on this?

Thanks,

Amanda Huber