Whether you are looking to hone in on particular candidates you already have in your database or simply to clean up your data, Loxo has full Boolean search capabilities built into your people, jobs, and company pages for you.

This article shares tips and tricks to help you best utilize your pre-existing database for sourcing.

Blank fields (blank text, blank numbers, blank dates, hierarchy)

Who recently updated a person

Custom fields

Find the people who you have had no contact with

Date range in your database

Who is/is not in a specific job

Boolean Search Workshop Video (~1 hr)

Search Specific Fields

Each field has a specific name that you can search using the Boolean search bar. When you search these specific fields, you are searching for entries or values in those fields directly instead of keywords. For example, you could search your database for people who had the past title of "VP of Sales.". To do that, you would create:

titles:"VP of Sales"

Or you could search your database for people with the current title of VP of Sales. That search would look like:

current_title:"VP of Sales"

The above two searches are different than just searching "VP of Sales" in your power search bar. The difference is that they are searching specifically past title and current title fields only, respectively.

So how do you know what the specific field names are? Below is a list of the most common that you can use. Remember, this format (with the colon) when you are using these searches:

field_name:"your search words"

*One thing to note, there is NO space after the colon when using Boolean*

Pre-built Searchable Fields

Searchable Fields within your People tab

Searchable Fields within your Jobs tab

Searchable Fields within your Companies tab

Searchable Fields within your People tab:

Field Name
name zip city state country macro_location description (Intake Notes) emails email_type_ids:<number> (<number> = the value of the filtered field in URL) phones phone_type_ids:<number> ((<number> = the value of the filtered field in URL) linkedin* id (search by a Loxo ID number)	skills resumes3 (resume) last_activity_at created_at updated_at titles companies compensation compensation_notes current_title current_company current_compensation started_working_at tag_names job_person_owners global_status_id list_ids

*As a reminder, Loxo has no affiliation with LinkedIn, X, Facebook, or any social networks. For further details related to third parties and non-Loxo products or services, you can reference the Loxo Master Subscription Terms of Service.

These searches will best support you in filtering for who DOES have something particular you need:

Resumes	Emails	Phone Number
_exists_:resumes3	_exists_:emails	_exists_:phones

These searches will best support you in filtering for who DOES NOT have something particular you need:

Resumes	Emails	Phone Number
not _exists_:resumes3	not _exists_:emails	not _exists_:phones

If you are looking for people without any contact information, the boolean is as follows:

not _exists_:emails AND not _exists_:phones

Searchable Fields within your Jobs tab:

Field Name
title published description internal_notes address zip	salary published_at created_at updated_at company_name macro_address

Searchable Fields within your Companies tab:

Field Name
name url description addresses global_status_id	emails phones created_at updated_at

Data Cleanup Search Types (click the arrow to compress or expand)

Contacts with missing information

Use Boolean strings to filter for contacts with missing information. Simply add this string to the search bar:

To get a list of all people without an email address on their profile:

not _exists_:emails

To get a list of all people without phone numbers on their profile:

not _exists_:phones

To get a list of all people without a current company on their profile:

not _exists_:companies

To get a list of all people without an owner on their profile:

not _exists_:owned_by_id

To get a list of all people without a location on their profile:

(NOT _exists_:city) AND (NOT _exists_:macro_location) AND (NOT _exists_:state) AND (NOT _exists_:address) and (NOT _exists_:country) AND (NOT _exists_:zip)

*To find people WITH this data, remove the "not" ie "_exists_:emails"

Block/locked companies or people

Search your database for all the companies or people that are blocked / locked in your database:

blocked:true

Records that have no owner

Search your database for all the records that have no owner.

not _exists_:owned_by_id

Blank fields (text, numbers, dates, hierarchy, etc)

To search for blank text fields, use the following:

not _exists_:custom_text_1_values

To search for blank numeric fields, use the following:

not _exists_:custom_numeric_range_1_values

To search for blank date fields, use the following:

not _exists_:custom_date_range_1_values

To search for blank hierarchy fields, use the following:

not _exists_:custom_hierarchy_1_values

(Click here to learn how to find the custom hierarchy value # for a custom field)

Published or unpublished jobs

Search your database for published and unpublished jobs. Simply navigate to your Jobs page and enter either of the Boolean strings:

published:true

(-published:*) OR published:false

Who recently updated a person

Search your database for who recently updated a person:

updated_by_id

You can also add not _exists_: or _exists_: to the front of the string

Custom fields

If you have created custom fields, you may filter them using the following strings. If you have more than one hierarchy column, update the "1" to represent the desired column number.

 _exists_:custom_hierarchy_1_values. (see below to learn how to identify the custom hierarchy field number)
 
_exists_:custom_text_1
 
_exists_:custom_numeric_range_1
 
_exists_:custom_date_range_1

How to identify the desired column number

Start in the People tab
Use the filter to select the custom field you wish to identify. Add a single search parameter for this field.
Find the field name in the URL; it begins with the "custom" examples listed above:
The numeric value is the specific value for this particular custom field.
The number after the = sign is the value for the parameter you selected for this custom hierarchy field. Other examples will reflect the manual input you entered, such as the text or number you searched for in a text, numeric or date field.

People you have had no contact with

To search for people that have yet to be contacted, use the following string:

not _exists_:last_contacted_at

Date range

The formatting for dates is YYYY/MM/DD.

To search by excluding a date range, use the following:

last_contacted_at:[2026-01-01 TO 2026-02-01] OR last_contacted_at:[2026-04-01 TO 2026-04-15]

Who is/is not in a specific job

To search your people page for who is in a job, you can use the following search, where xxxxx is replaced with the specific job ID. This will allow you to be on your People page and see who is already in that job.

candidate_job_ids:xxxxx

To search your People page for those who are not in a job, you can use the following search, where xxxxx is replaced with the specific job ID. This will allow you to be on your People page and see everyone but those who are in that job.

NOT candidate_job_ids:xxxxx

Boolean Within Your Database