Bug
Unable to perform a query when '!=' is included as a parameter for the WHERE clause in the query filter.
| Bug ID Number | BUG-000129886 |
|---|---|
| Submitted | April 3, 2020 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS Online |
| Version found | 8.1 |
| Operating System | Windows OS |
| Operating System Version | 10.0 |
| Status | Will Not Be Addressed |
Additional Information
The only difference is that ‘<>’ is in line with the SQL-92 ISO standard, and ‘!=’ is not. Due to the fact that enables StandardizeQuery: true, use the '<>' operator as it follows the ISO standard.Workaround
Use the not-equal-to operator for the Where clause as '<>' instead of '!='. For example, use:
- OBJECTID <> 1.
- Object ID does not equal 1.
Steps to Reproduce
Bug ID: BUG-000129886
Software:
- ArcGIS Online
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