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

Question

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.

poup3.png

popup.png

popup2.png

jcokin1 · Answer

No worries @DenisLalonde. Glad that these bulletin boards are here so we can help each other out. Keep posting!

DenisLalonde · Answer

Thanks @jcokin1, that did the trick.

To futher help out the next person, I found that this workaround didn't work when done within the view on SQL Server's end. It had to be done in within Pro's "Edit Query Layer" dialogue... at least in my environment anyway.

jcokin1 · Answer

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.