topic Version 4.24 -> 4.25 or 4.26 - Default generated feature service query WHERE clause is no longer the same in ArcGIS JavaScript Maps SDK Questions

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

YimYean — Tue, 07 Mar 2023 02:21:56 GMT

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

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

UndralBatsukh — Tue, 07 Mar 2023 20:07:35 GMT

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.

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

JoelBennett — Wed, 08 Mar 2023 18:14:13 GMT

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

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

YimYean — Wed, 08 Mar 2023 22:46:41 GMT

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.