Check if a value is not in a list in Application Insights Query Language?

10.2k views Asked by At

Is there a shorter way to check if a property, say user_id is not within a given list:

customEvents 
| where user_Id != 123
    and user_Id != 234
    and user_Id != 345
1

There are 1 answers

1
Ivan Glasenberg On BEST ANSWER

You can use the !in operator, code like below:

customEvents 
| where user_Id !in (123,234,345)