Doubt Expression do a Search

santiagopoli3 · 2023-01-22T01:35:41.093Z

I have 2 lists:

List one: users.
List two: emails.

I want to do a search for all emails that are not in Users data type.

But I’m not getting it. How should I do that do a search?

tylerboodman · 2023-01-22T01:45:01.335Z

Do a search for [your email datatype]:each item's email :minus list Do a search for User:each item's email

santiagopoli3 · 2023-01-22T01:46:20.686Z

thank you very much!!! I though on that but my question is, can it be negative? Or that would just be if I use “count”?

tylerboodman · 2023-01-22T01:47:05.811Z

What I said would give you a list of emails addresses. No negative numbers unless you start doing :count on each search and subtracting the numbers

santiagopoli3 · 2023-01-22T02:27:53.024Z

What’s wrong?

I want to search for all candidates that hasn’t been registred (whose email is not in the users database)

both userss’ email and candidates email are a text field

santiagopoli3 · 2023-01-22T02:29:52.931Z

I think I need something like this but I can’t figure it out

tylerboodman · 2023-01-22T02:31:52.354Z

What I described gives you a list of texts (emails), not a list of Candidates which is why it doesn’t like it.
Try Do a search for Candidate with the constraint email isn't in Do a search for User:each item's email

I think this is similar to what @mikeloc posted here before he deleted it

mikeloc · 2023-01-22T02:33:30.686Z

The post was marked as solved right before I posted my reply, so it didn’t seem like there was any reason to muddy the waters with another post.