Special characters in feature effect query

[AndrewMurdoch1]

Good Day

Is it possible to run a feature effect query using special characters in the field name?  Could I run:

const query = {
    where "good(%) = '100'"
}

I know using arcade, you can do "When($feature['good(%)'] = '100')", but when I try that with non-arcade queries it doesn't work. Is there a way to pull this off?

Thanks

[Noah-Sager]

I think the query.where property or the filter.where should work for you. Can you share a public app that reproduces the issue? I don't have special characters in a field name to test with.

https://developers.arcgis.com/javascript/latest/api-reference/esri-rest-support-Query.html#where

https://developers.arcgis.com/javascript/latest/api-reference/esri-layers-support-FeatureFilter.html...

[UndralBatsukh]

Hi there, 

Field names containing special characters are not supported in any layer when using the JavaScript API.
Could you let us know which type of layer you're working with? This documentation outlines the characters that are not permitted in field names. You need to normalize your field names to get your layer working propertly.

[AndrewMurdoch1]

We're using Stream Layers, and I know you're not meant to use them, but people don't listen and keep trying to use bad naming conventions, so I was looking for a workaround, which I don't think exists.

Thanks

[UndralBatsukh]

There isn't a workaround for this. It seems like you might be creating a client-side StreamLayer. You can review the field names and remove any special characters when setting up the layer. We'll be updating the documentation to include the requirements for field names.

[AndrewMurdoch1]

Thank you, that would be helpful, I know this is a stupid question, so thanks for entertaining it.  I'm using a server Stream, so I can't modify the fields, which is what caused the problem, the people sending the data don't believe it's an issue.  Hence why i posted this thread.