Bogue
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').
| Numéro d’ID de bogue | BUG-000110490 |
|---|---|
| Envoi | December 29, 2017 |
| Dernière modification | June 25, 2025 |
| S’applique à | ArcGIS for Desktop |
| Version trouvée | 10.5.1 |
| Système d’exploitation | Windows OS |
| Version du système d’exploitation | 7.0 64 Bit |
| Statut | Will Not Be Addressed |
Informations supplémentaires
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.Solution de contournement
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)Étapes pour reproduire
ID de bogue: BUG-000110490
Logiciel:
- ArcGIS for Desktop
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support