Matching Logic Options
Definitions for supported Query Builder matching logic options
The following matching logic options are used with our Query Builder Tool to build search queries.
When writing rules based on fields with canonical values, make sure to use the exact value listed in the corresponding Canonical Value Table. For example, if you write a query for profiles in the USA with the location_country
field, you need to enter united states
exactly as shown in the Canonical Countries table in order to get successful matches.
- = (Equals): This matching logic is used to find exact matches for the entered value(s). For example, if you select the
location_name
field and set the matching logic as "=", enteringsan francisco, california, united states
will match profiles with the exact location "San Francisco, California, United States." - != (Not Equals): This logic is used to exclude profiles that have a specific value. For example, if you set the matching logic as "!=" and enter
Manager
for thejob_title
field, profiles with the job title "Manager" will be excluded from the search results. - contains: This logic is used to find profiles that contain the entered value(s) as a substring within a particular field. For example, using the "contains" logic with the
company_name
field and entering"Tech"
will match profiles with company names like "ABC Technologies" or "XYZ Tech Solutions." - beginsWith: This logic is used to find profiles where a particular field starts with the entered value(s). For instance, if you set the matching logic as "beginsWith" for the
first_name
field and enter"John"
it will match profiles with first names like "John," "Johnson," or "Johnathan." - endsWith: This logic is used to find profiles where a particular field ends with the entered value(s). For example, if you set the matching logic as "endsWith" for the
email
field and enter"@gmail.com"
, it will match profiles with email addresses ending in "@gmail.com." - doesNotContain: This logic is used to exclude profiles that contain the entered value(s) as a substring within a specific field. For instance, using the "doesNotContain" logic with the
job_title
field and entering"Manager"
will exclude profiles with job titles containing the word "Manager." - doesNotBeginWith: This logic is used to exclude profiles where a particular field does not start with the entered value(s). For example, if you set the matching logic as "doesNotBeginWith" for the
company_name
field and enter"ABC"
, profiles with company names like "ABC Technologies" or "ABC Corporation" will be excluded. - doesNotEndWith: This logic is used to exclude profiles where a particular field does not end with the entered value(s). For instance, if you set the matching logic as "doesNotEndWith" for the
email
field and enter"@yahoo.com"
, profiles with email addresses ending in "@yahoo.com" will be excluded. - notNull: This logic is used to find profiles where a particular field is not empty or null. For example, if you set the matching logic as "notNull" for the
phone_numbers
field, it will match profiles that have at least one phone number. - in: This logic is used to match profiles where a particular field's value is contained within a list of provided values. For example, if you set the matching logic as "in" for the
industry
field and enter"technology,finance,healthcare"
, it will match profiles with industries listed as either "technology," "finance," or "healthcare." - notIn: This logic is used to exclude profiles where a particular field's value is present in a list of provided values. For instance, if you set the matching logic as "notIn" for the
location_country
field and enter"united states,canada"
, profiles with countries listed as either "united states" or "canada" will be excluded.
Updated 2 months ago