Select to view content in your preferred language

parseWhereClause ('@arcgis/core/core/sql.js') should return the parsed where clause

181
0
03-30-2026 06:05 AM
Status: Open
Labels (2)
DanRussell
Occasional Contributor

It seems to me that it would be useful if `parseWhereClause` from `@ArcGIS/core/core/sql.js` returned the actual parsed where clause as a property of the returned `WhereClause` object, or via its `toString()` method.

This would allow a developer to actually use that parsed string as the where clause in their query or definition expression. It would presumably be well-formed, trimmed, white-space removed, etc.

The function: https://developers.arcgis.com/javascript/latest/references/core/core/sql/#parseWhereClause

The returned object: https://developers.arcgis.com/javascript/latest/references/core/core/sql/WhereClause/

Anyone using this function would likely be interested in using (or at least seeing) the parsed string. Currently, you can only "ask" this function about your where clause: Is it standardized? What fields does it have? Will it work for this query? Presumably, you could build the query yourself from the `parseTree` property, but that seems like a chance to introduce errors after you've called the function.

But there's definitely one thing you don't get when you call `parseWhereClause`: the parsed where clause.