azureazure-application-insightsms-app-analyticsaiql

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

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
Solution

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

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