1. Vainu Help Center
  2. Sales Prospecting
  3. Get Familiar With Category-Specific Filters

Make AND, OR and NOT searches & keyword search logic

There are a few things that you should know about the logic behind the searches in Vainu

We understand that finding the right filters and understanding how the results are generated can take a little while, but don't worry –  we'll walk you through the basics of the search logic in Vainu.



You can change filter type between AND, OR and NOT by clicking it.

“OR” searches are the basic type of search. All filters are by default “OR” searches meaning if you choose an option in a filter it will be OR unless changed. The search below would translate as find me companies that have Giosg OR Zendesk OR Userlike Chat. So the company needs to have either one of those three technologies and then they will be shown for you.

Näyttökuva 2019-11-26 kello 9.57.04

“AND” and "ALL" searches

You can change filter type between AND, OR and NOT by clicking on it.

“AND” search is the second most common search option in Vainu. When selecting different filters they work together using “AND” option. If you choose Revenue filter and Employee number filter it means that both arguments in Revenue AND Employee number need to be true for your search to work.

“AND” is the basic option between filters. The search below translates as companies need to have revenue over 900 000 euros AND the companies need to have 8 or over 8 employees. If both of them are true for the company then you will see it in your results.


The other type of “AND” searches are the multiple options inside one filter. The picture below would translate as I want to find companies that have Giosg OR Userlike on their website AND Zendesk. Green color tells you if the filter is using the AND search option.

Näyttökuva 2019-11-26 kello 9.58.08

When you select multiple values which green color, the search needs to include ALL of the selected values in your search results. Search below would translate: "Companies that have a Website and do have both Wordpress and SLL/TLS technologies used on their website. "
Näyttökuva 2019-11-26 kello 9.27.20

“NOT” Negative searches

You can change filter type between AND, OR and NOT by clicking it.

Negative searches can be used in multiple ways. Check the examples below for more information. Remove companies in static list from your search results, the picture below would translate as REMOVE companies found on static list “Domain import” from my current search.



Find companies without specific website technology. The picture below would translate as find me companies that DON’T have website on their company profile.



Find companies that have LESS than 1M revenue AND companies that have over 9M revenue. The picture below would translate as REMOVE companies from my results that have revenue between 1M and 9M.


Keyword search and company name search

All the AND, OR, NOT filter options apply to keyword searches also.

“OR” Example: Website needs to have either word “tech” OR “computer”

Näyttökuva 2019-11-26 kello 9.28.27

“AND” Example: Website needs to have word “tech” AND “computer”

Näyttökuva 2019-11-26 kello 9.28.36

“NOT” Example: Website needs to have word “tech” BUT NO word “computer”

Näyttökuva 2019-11-26 kello 9.28.51

Vainu automatically searches any words that include your search word. Meaning if you type in “tech”, Vainu searches also for words TECHnology, TECHnologies, TECHnological etc.

💬 Should you have any questions, please contact us through the chat in the bottom right corner or by sending an email to support@vainu.io