topic Re: Query Layers or Views don't display popups in New Map Viewer on AGOL or Enterprise in ArcGIS Online Questions

Query Layers or Views don't display popups in New Map Viewer on AGOL or Enterprise

dhaag — Wed, 03 May 2023 16:29:54 GMT

I have a database view (have attempted with just a query layer as well) that works and has worked in the past to display a custom popup in AGOL and Enterprise. This layer now won't display the popup in the new map viewer or in dashboards. If I switch to the Classic map viewer, the popup displays without issue. Also, if I publish the layer as a hosted service on AGOL it also works fine. Seems to only be when it is dynamic from our SDE and in the new map viewer.

I've attached 3 images. popup shows what it looks like in Classic Viewer. popup2 shows that when configuring it in the new map viewer, it will display, but if you click on any of the points on the map, no popup displays. poup3 shows a details widget in dashboards showing No Data.

Re: Query Layers or Views don't display popups in New Map Viewer on AGOL or Enterprise

RhettZufelt — Wed, 03 May 2023 19:02:38 GMT

Your example appears to be point related, so may not apply, but I have had similar issues to this in dashboards using SDE data/views.

Turns out AGOL doesn't play well with fields that are not actually part of the feature class (Shape.STArea(), Shape.STLength()) and are added/calculated on the fly when you access them.

When I modified my view syntax to cast them to a different name, all seems to work fine:

SELECT OBJECTID, Owner, recnum, Shape.STLength() AS Length

rather than:

SELECT OBJECTID, Owner, recnum, Shape.STLength()

In fact, I had to create the views in order to overcome this rather than just using the feature class itself.

Hope this helps,

Re: Query Layers or Views don't display popups in New Map Viewer on AGOL or Enterprise

jcokin1 — Fri, 04 Oct 2024 17:21:20 GMT

It is NOT just points that cause the problems. This is for all geometry types! I have the exact same error with multiple query feature layers (points, lines and polygons) sourcing my SQL server database tables.

Due to the complexity of the tables in our RDBMS and the amount data stored (30+ years) in these tables.... they can NOT be exported and reloaded as simple feature layers within an SDE and must reside as SQL server tables hence the use of the Query Feature Layer option

@dhaag or @RhettZufelt did anyone flag this with ESRI as a bug within Standard Map Viewer? I see the post is almost a year and half old 🤷‍

I have 20+ query feature layers published to portal and no way to access the identify / pop-up results for any of the layers with the new "Standard Map Viewer" vs "Classic Map Viewer"( classic works with pop-ups with query feature layers published to Portal).

@BernSzukalski and @RussRoberts ......I am tagging you guys on this as we could use someone from ESRI to see if this bug was ever flagged and has a number or it needs to be cataloged and brought to the AGOL / Portal teams attention.

I have only come across this community post that talks about the issue.

Re: Query Layers or Views don't display popups in New Map Viewer on AGOL or Enterprise

RhettZufelt — Thu, 10 Oct 2024 14:46:35 GMT

Only related bug I reported on this was:

BUG-000152780 : In ArcGIS Dashboards, unable to use Shape.STLength() field from a map service in Table and Details elements. "Cannot access data" is shown.

Re: Query Layers or Views don't display popups in New Map Viewer on AGOL or Enterprise

jcokin1 — Sun, 01 Mar 2026 23:14:23 GMT

Ok, the odd workaround that I found was to duplicate the unique ID in the SQL Query but giving it a different name. ex.

select FCode AS RowID, FCode, ...... (plus whatever else is in your SQL statement).

By duplicating the unique ID which in this instance is FCODE ......from some strange reason the Query Feature Layer when published up to Portal would suddenly work and the pop-up was there in both Standard Map Viewer and Classic Map Viewer for Portal. Hope this helps that next person out.