CODEWITHSUNDEEP
azureazure-application-insightsms-app-analyticsaiql
Mikkel R. Lund
Mikkel R. Lund

Reputation: 2627

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

Upvotes: 6

Views: 11440

Answers (1)

Ivan Glasenberg
Ivan Glasenberg

Reputation: 29950

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

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

Upvotes: 12

Related Questions