Bug
Unable to validate query expressions involving the DATE function in ArcGIS Pro for the feature layers referencing an enterprise geodatabase when the standardized queries is disabled in ArcGIS Server.
| Bug ID Number | BUG-000118009 |
|---|---|
| Submitted | November 7, 2018 |
| Last Modified | June 23, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 2.1.1 |
| Operating System | Windows OS |
| Operating System Version | 2016 64 Bit |
| Status | As Designed |
Additional Information
This is the expected behavior with standardized queries. Please see the workaround mentioned to use standardized SQL.Workaround
- Configure the ArcGIS Server to only allow standardized queries by setting the system properties to {"standardizedQueries": "true"}.
- Use the standardized SQL CURRENT_DATE() function to compose the query.
Steps to Reproduce
Bug ID: BUG-000118009
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App