Why is Search not working but search for NOT != does work?

KeithH — Fri, 08 Apr 2022 14:53:28 GMT

Hi All,

I am doing a very simple search over All Time of:

index=index=orafin sourcetype=ORAFIN2

It returns 26 rows and, as this shows, all have a transaction_type value:

If I then select D it adds that to the search but retuns NO rows:

Oddly if I change the search to a double negative I get my data:

Whats going on?

Hoping to be enlightened,

Keith

Re: Search not working but search for NOT != does work.

VatsalJagani — Fri, 08 Apr 2022 05:16:32 GMT

---
Consider accepting/upvoting this answer if it is helpful!!!