5

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
John Gardner
  • 24,225
  • 5
  • 58
  • 76
Mikkel R. Lund
  • 2,336
  • 1
  • 31
  • 44

1 Answers1

10

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

customEvents 
| where user_Id !in (123,234,345)
Ivan Glasenberg
  • 29,865
  • 2
  • 44
  • 60