topic Re: setDefinitionExpression & sql functions in ArcGIS JavaScript Maps SDK Questions

setDefinitionExpression & sql functions

ZorbaConlen1 — Mon, 10 Sep 2018 23:47:49 GMT

Hi,

I'd like to apply a def query to a feature layer in my app. I'm running into an issue, I think with the expression I'd like to use. It's a bit complicated in that it uses the IIF sql function (returns one of two values based on if a boolean expression evaluates to true or false). No error, but no results are returned and the same expression returns results in sql (ssms). I'm guessing there are limits on what sql functions one can use, but not finding any documentation of that.

Anyone know if it's documented as to what is valid expression?

Thanks

Re: setDefinitionExpression & sql functions

RobertScheitlin__GISP — Tue, 11 Sep 2018 12:51:58 GMT

Zorba,

Here is some documentation on support SQL:

SQL reference for query expressions used in ArcGIS—Help | ArcGIS Desktop

As far as I know IIF conditions are supported

Define parameters in a query layer—Query layers | ArcGIS Desktop

One thing it depends on is the setting on ArcGIS for standardized queries:

About standardized queries—ArcGIS Server Administration (Windows) | ArcGIS Enterprise

Re: setDefinitionExpression & sql functions

ZorbaConlen1 — Tue, 11 Sep 2018 20:41:11 GMT

Thanks Robert. I wasn't sure if the standardized queries setting just applied to query tasks. Seems it applies also to def queries. I'll have to re-write the query since I'd rather not change the arcgis server setting.