idea ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue in Data Pipelines Ideas

ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue

Amanda__Huber — Tue, 17 Dec 2024 20:21:38 GMT

Hello,

It appears there is no functionality for the expression builder to accomodate "Current Year". This functionality is built into other Esri applications and has a very strong use case in your application as well. This seems to be an equivilancy issue.

This option is critical, as many individuals have a need to filter based on annual operations/summaries.

There is no option to set current year or even filter for year.

Example of ArcGIS Dashboard's Expression builder-

Please advise,

Amanda Huber

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue - Status changed to: Under Consideration

BethanyScott — Tue, 17 Dec 2024 20:46:21 GMT

Hey @Amanda__Huber ,

Thank you for reaching out with this feedback.

While querying for "this year" is not currently supported, what you could do is add a filter that uses an "is between" clause. This can be used to find records that fall within a specific date range, such as January 1, 2024 - December 31, 2024.

In Query builder, it would look something like this:

This query would need to be updated in the data pipeline yearly, but hopefully it can get you one step closer to your desired results.

Thanks again for reaching out! We value your input.

Bethany

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue

Amanda__Huber — Tue, 17 Dec 2024 20:54:48 GMT

Hi @BethanyScott

Thanks for the quick response!

Unfortunately we'd like to avoid having to update the query yearly. This would somewhat defeat the purpose of it being automated/in Data Pipelines since we could just run this query manually using ArcGIS Pro GP tools. We'd need it to be "current year" similar to how "in the last 1 year" expression functions across other Esri expression builders.

Thanks,

Amanda Huber

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue

Amanda__Huber — Wed, 05 Mar 2025 21:20:28 GMT

Update-

Exciting news! It looks like the Esri Pipelines Team implemented this in the Feb 2025 AGOL update. Learn more about it here: https://www.esri.com/arcgis-blog/products/arcgis-online/announcements/whats-new-in-arcgis-data-pipelines-february-2025/#:~:text=Filter%20your%20data%20using%20dynamic%20time%20queries

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue - Status changed to: Implemented

BethanyScott — Wed, 05 Mar 2025 21:34:48 GMT

idea ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year *Equivilancy Issue* in Data Pipelines Ideas

ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year *Equivilancy Issue*

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year *Equivilancy Issue* - Status changed to: Under Consideration

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year *Equivilancy Issue*

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year *Equivilancy Issue*

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year *Equivilancy Issue* - Status changed to: Implemented

idea ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue in Data Pipelines Ideas

ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue - Status changed to: Under Consideration

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue

Re: ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year Equivilancy Issue - Status changed to: Implemented