Bug
When querying a date field of a SDE geodatabase feature class, the Select By Attribute tool in ArcGIS Pro fails to preface the date being queried with the necessary delimiter ('date').
| Bug-ID-Nummer | BUG-000110490 |
|---|---|
| Eingereicht | December 29, 2017 |
| Zuletzt geändert | June 25, 2025 |
| Gilt für | ArcGIS for Desktop |
| Gefunden in Version | 10.5.1 |
| Betriebssystem | Windows OS |
| Betriebssystemversion | 7.0 64 Bit |
| Status | Will Not Be Addressed |
Zusätzliche Informationen
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.Workaround
Once the query is constructed, click the ‘Switch to Edit SQL Mode’ button if not already in this view, and manually add the word 'date' in front of the date the user is selecting on.Example: Before:superhero.DATA_CREATOR.Time.Date = '2004-05-03 00:00:00' AND (Sheet1$.Name IS NOT NULL OR Sheet1$.Name IS NULL)After:superhero.DATA_CREATOR.Time.Date = date '2004-05-03 00:00:00' AND (Sheet1$.Name IS NOT NULL OR Sheet1$.Name IS NULL)Schritte zur Reproduzierung
Bug-ID: BUG-000110490
Software:
- ArcGIS for Desktop
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen