Version 4.24 -> 4.25 or 4.26 - Default generated feature service query WHERE clause is no longer the same

[YimYean]

Hello,

I've been testing our version 4.11 until 4.26 to try to see where things changed and it looks like in 4.25+ the generated feature service query has changed.

Before:

After: The UPPER has changed to LOWER and the LIKE clause no longer includes the % at the beginning.  Is this expected change or bug?  If a bug how would I go about overriding it to perform custom query?

Best,

Yim

[UndralBatsukh]

Hi there, 

Do you have a reproducible case for this? I am not able to reproduce what you are describing here. I tested it and the following code

document.getElementById("queryButton").addEventListener("click", ()=> {
  const where = "UPPER(STATE_NAME) LIKE 'Miss%'"
  featureLayer.queryFeatures({where: where}).then((results)=>{
    console.log(results)
  });
});

results in this query. 

 

[YimYean]

Thanks @UndralBatsukh for the reply, it seems like my issue is related to the issue that @JoelBennett commented and has more details into the issue.

[JoelBennett · Accepted solution]

It seems likely you're seeing this in relation to the Search widget.  If that's the case, please see this thread.