idea Full-blown SQL query on AGOL Feature Service data in ArcGIS Pro in ArcGIS Pro Ideas

Full-blown SQL query on AGOL Feature Service data in ArcGIS Pro

Bud — Fri, 11 Oct 2024 17:45:50 GMT

@JustinH mentioned a querying/join requirement in 1:M Join to Pull feature with Specific Attribute information:

I pull all of the data from an AGOL Feature Service that our organization is hosting.

It took several awkward geoprocessing steps to achieve the required results. It would have been a lot more efficient to just write a simple SQL query with a LEFT JOIN.

Re: Full-blown SQL query on AGOL Feature Service data in ArcGIS Pro

AlfredBaldenweck — Wed, 28 Aug 2024 13:25:05 GMT

I'm all for better (or any) SQL implementation in AGOL; this would be nice.

Re: Full-blown SQL query on AGOL Feature Service data in ArcGIS Pro - Status changed to: Needs Clarification

RussellBrennan — Thu, 18 Jun 2026 15:08:35 GMT

@Bud Could what you are requesting be accomplished with views, specifically a joined view?

https://doc.arcgis.com/en/arcgis-online/manage-data/create-hosted-views.htm#ESRI_SECTION1_FB2E757804014C88B5E5A6D9404A23E1