How do I escape a string starting with "-" in a Filter Expression?

[ryan_bouquet]

Knowledge Drop

Last tested: May 29, 2019
 

Filter expressions read in the character "-" to mean NOT, so filtering on a string value starting with a dash will actually return all results EXCEPT the specified string.

To get around this we can escape the string with a carat. For example: "-value" will become "^-value". This will then filter correctly for strings with the value "-value".

This content is subject to limited support.