I need to search for all users who have not registered for an event. Five years ago, I asked the question, and the answer was to create a group of users who did register and then do an include/exclude search.
The thing is that I need to do this on a regular basis, for many events. Creating a group for every event became too cumbersome.
I am trying to figure out how I can do this search, perhaps using the data processor extension. Where I am stuck is figuring out how to express my intention: "all users who have not registered".
I tried using a search on Participants. But if someone has not registered, they are not a participant. So using a search like "all participants for event X where status is not Registered" only shows me people who did register but whose status is now Attended or Canceled for example. It does not show me people who have not registered.
The data processor extension allows you to join data, but I don't see how it lets you do the opposite of a join. Essentially to say "select all users" plus "exclude (reverse of join) any person who is a Participant for this event".
I believe this is where I am thinking about the problem wrong. SQL doesn't have such an exclusion call, instead you are supposed to re-think the question so that it becomes a query where join is possible.
So can anyone help me re-think this so that using "join" function of data processor is possible?