漏洞
When writing a definition query in ArcGIS Pro on a feature class from a SQL Server database, and the DATEDIFF function is used, the query fails if there are no records returned.
| 漏洞 ID 编号 | BUG-000126459 |
|---|---|
| 已提交 | October 31, 2019 |
| 上次修改时间 | May 16, 2025 |
| 适用范围 | ArcGIS Pro |
| 找到的版本 | 2.4.2 |
| 操作系统 | N/A |
| 操作系统版本 | N/A |
| 状态 | Non-Reproducible |
附加信息
This issue is no longer reproducible. When no records are found, the validation process returns a warning, and that is expected.解决办法
- Avoid using the DATEDIFF SQL function in the definition query. For example, 'Date<(GETDATE()-1)'.
- Alternatively, use the same expression in ArcMap instead.
重现步骤
漏洞 ID: BUG-000126459
软件:
- ArcGIS Pro
当漏洞状态发生变化时获得通知
发现关于本主题的更多内容
搜索相关信息
查找与此主题相关的培训
探索想法并提供反馈
获取来自 ArcGIS 专家的帮助
下载 Esri 支持应用程序