setDefinitionExpression & sql functions

[ZorbaConlen1]

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

[RobertScheitlin__GISP]

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 

[ZorbaConlen1 · Accepted solution]

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.