I have a .net core application that logs various events with properties (WorkItem, EventName, etc). I need to query WorkItems that have never had certain events kinda like a SQL NOT Exists.  I can filter out the events I don't want but I cannot select where they never existed. WorkItem | Event 1234          | Task Created 1234          | Retrieval Ready 1234          | NIGO Completed 5678          | Retrieval Ready 9012          | Task Created 9012          | Retrieval Ready The query should return all WorkItems with events that equal Retrieval Ready and not NIGO Completed...example result. WorkItem | Event 5678          | Retrieval Ready 9012          | Retrieval Ready ... View more