laptop and a wrench

Bug

Unable to perform the query operation in ArcGIS Experience Builder on the PostgreSQL data. The error message, "Error: Underlying DBMS error [ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...ere ((krb.bavaria.shape && $1) = 't') ORDER BY gem_name A... ^::SQLSTATE=42P10] [Bavaria]." is returned when using the filter if the current extent trigger is added to the Map widget.

Last Published: January 4, 2023 Portal for ArcGIS
Bug ID Number BUG-000154714
SubmittedDecember 22, 2022
Last ModifiedFebruary 11, 2025
Applies toPortal for ArcGIS
Version found11.0
Operating SystemWindows Server
Operating System Version2019 64 Bit
StatusDuplicate

Steps to Reproduce

Bug ID: BUG-000154714

Software:

  • Portal for ArcGIS

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options
Esri Support AI Chatbot