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 ModifiedJune 5, 2024
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