AnsweredAssumed Answered

setDefinitionExpression & sql functions

Question asked by ZConlen@bellevuewa.gov_cobgis on Sep 10, 2018
Latest reply on Sep 11, 2018 by ZConlen@bellevuewa.gov_cobgis

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

Outcomes