AnsweredAssumed Answered

setDefinitionExpression and LIKE operator and wildcard % issues

Question asked by jonssong on Sep 24, 2014
Latest reply on Sep 24, 2014 by jonssong

I am using the setDefinitionExpression on some of my FeatureLayers. This works fine in most cases but I believe there might be a bug in the API when it comes to the LIKE operator and the % wildcard.

 

When using expressions such as;

myField LIKE '%Ca%' 

I get no results even though "myField"  has several records including the word "Catchment"

 

however I always get correct results when just using a single character between the % wildcards, such as

myField LIKE '%C%' 

or

myField LIKE '%a%' 

 

interestingly, it does sometimes work as expected with multiple characters (depends on the character combination), e.g.

myField LIKE '%tr%' 

works fine and returns the correct features

 

I suspect this may be a bug in the API since the getDefinitionExpression always returns the expression exactly as I stated it.

 

In essence, it appears to be a parsing issue with %xx in the definition expressions.

 

I'm on version 3.10 now and I am pretty sure this was not an issue in 3.8.

 

Anyone else had this issue?

Thanks

Outcomes