nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Accepted answers

JoelBennett

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

All comments

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.

Screenshot 2023-03-07 at 12.06.43 PM.png

JoelBennett

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

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.