Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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
like image 516
Mikkel R. Lund Avatar asked Mar 06 '23 14:03

Mikkel R. Lund


1 Answers

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

customEvents 
| where user_Id !in (123,234,345)
like image 90
Ivan Yang Avatar answered May 10 '23 20:05

Ivan Yang