laptop and a wrench

漏洞

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').

上次发布: February 8, 2018 ArcGIS for Desktop
漏洞 ID 编号 BUG-000110490
已提交December 29, 2017
上次修改时间June 25, 2025
适用范围ArcGIS for Desktop
找到的版本10.5.1
操作系统Windows OS
操作系统版本7.0 64 Bit
状态Will Not Be Addressed

附加信息

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.

解决办法

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)

重现步骤

漏洞 ID: BUG-000110490

软件:

  • ArcGIS for Desktop

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项