In cases where providers do not define an idField and koop generates the OBJECTID property by default, requests with where parameters that include the OBJECTID will return zero features. This happens because the alasql library applies the WHERE clause to the data before the esriFy function that creates the OBJECTID. Since OBJECTIDs don't exist at that point, zero features are selected.
When no idField is set, and the where includes OBJECTID we need to strip that part of the where before it heads off to alasql.
In cases where providers do not define an
idFieldand koop generates theOBJECTIDproperty by default, requests withwhereparameters that include the OBJECTID will return zero features. This happens because the alasql library applies theWHEREclause to the data before theesriFyfunction that creates the OBJECTID. Since OBJECTIDs don't exist at that point, zero features are selected.When no
idFieldis set, and thewhereincludesOBJECTIDwe need to strip that part of thewherebefore it heads off to alasql.