laptop and a wrench

Bug

The GROUP BY SQL clause in data access using cursors does not work as expected.

ArcGIS Pro
Bug-ID-Nummer BUG-000159926
EingereichtJuly 18, 2023
Zuletzt geändertJanuary 6, 2026
Gilt fürArcGIS Pro
Gefunden in VersionN/A
BetriebssystemWindows OS
BetriebssystemversionN/A
StatusAs Designed

Zusätzliche Informationen

The GROUP BY clause is an aggregation function, and columns must appear in the selected columns to be used in the aggregation GROUP BY clause. Applying a GROUP BY without aggregation columns such as SUM or MAX is unlikely to produce meaningful results but is possible by passing each column into the postfix, for example, "GROUP BY county, age, name." For examples that pass strings using the Python and keyword, this performs a boolean operation on the two strings, so the final string is returned. For example, test = 'a' and 'b' returns 'b'. Please refer to Python truth value testing available at https://docs.python.org/3/library/stdtypes.html#truth-value-testing for more information.

Schritte zur Reproduzierung

Bug-ID: BUG-000159926

Software:

  • ArcGIS Pro

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Esri Community

Nach zugehörigen Informationen suchen

Training

Nach Schulungen zu diesem Thema suchen

ArcGIS Ideas

Ideen erkunden und Feedback geben

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln