Most Simplified Explanation != is a field expression that returns every event that has a value in the field, where that value does not match the value you specify. Events that do not have a value in the field are not included in the results. For example, if you search for Location!="Calaveras Farms", events that do not have Calaveras Farms as the Location are returned. Events that do not have Location value are not included in the results. On the other hand, NOT is an operator that returns every event except the events that contain the value you specify. This includes events that do not have a value in the field. For example, if you search using: NOT Location="Calaveras Farms", every event is returned except the events that contain the value “Calaveras Farms”. This includes events that do not have a Location value. Here’s an example to illustrate the difference between the two methods. Suppose you have the following events: Table ID Name Color Location 101M3 McIntosh Chestnut Marin Meadows 104F5 Lyra Bay 104M6 Rutherford Dun Placer Pastures 101F2 Rarity Marin Meadows 102M7 Dash Black Calaveras Farms 102M1 Roan 101F6 Chestnut Marin Meadows 104F4 Pinkie Sorrel Placer Pastures If you search with Location!="Calaveras Farms", every event that has a value in the Location field, where that value does not match Calaveras Farms, is returned. Events that do not have a value in the Location field are not included in the results. The following events are returned: Output Table ID Name Color Location 101M3 McIntosh Chestnut Marin Meadows 104M6 Rutherford Dun Placer Pastures 101F2 Rarity Marin Meadows 101F6 Chestnut Marin Meadows 104F4 Pinkie Sorrel Placer Pastures If you search with NOT Location="Calaveras Farms", every event is returned except the events that contain the value Calaveras Farms. This includes events that do not have a Location value. The following events are returned: Output Table ID Name Color Location 101M3 McIntosh Chestnut Marin Meadows 104F5 Lyra Bay 104M6 Rutherford Dun Placer Pastures 101F2 Rarity Marin Meadows 102M1 Roan 101F6 Chestnut Marin Meadows 104F4 Pinkie Sorrel Placer Pastures
... View more