Special characters in feature effect query

Question

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

AndrewMurdoch1 · Answer

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.

UndralBatsukh · Answer

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 · Answer

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