​
Example: Search for Profiles with an Email Address

Retrieve up to 5 profiles with an email address in the database. This query checks for the existence of the profile_info.emails field. 
{
  "query": {
    "exists": {
      "field": "profile_info.emails"
    }
  },
  "limit": 5
}

​
Example: Search for Data Science Professionals

Search for 10 people working in data science. Using match query we perform a full text search, meaning that we may get people who currently work as data scientists or in a similar position. 
{
  "query": {
    "match": {
      "profile_info.current_title": {
        "query": "data scientist",
        "operator": "AND"
      }
    }
  },
  "limit": 10
}
Thanks to mapping profile_info.current_title as both text and keyword (See OpenSearch Mapping), we can easily perform an exact search on this field. Below we search for people whose role is titled “Data Scientist”. Mind that we use term query to perform the search. 
{
  "query": {
    "term": {
      "profile_info.current_title.raw": {
        "value": "Data Scientist"
      }
    }
  },
  "limit": 10
}

​
Combine Multiple Search Conditions

To perform a search based on multiple conditions, we need to use a boolean query. We want all the conditions to be met, so must clause is the proper one. The below query will return all Software Developers working at The Swarm company. For other logical operation refer to OpenSearch documentation. 
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "profile_info.current_title": {
              "query": "software developer"
            }
          }
        },
        {
          "match": {
            "profile_info.current_company_name": {
              "query": "The Swarm"
            }
          }
        }
      ]
    }
  }
}

​
Search for Recently Updated Profiles

Retrieve profiles in the Information Technology and Services industry that had their current job updated within a specific date range. This query uses a combination of range and term filters. 
{
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "profile_info.current_job_updated_at": {
              "gte": "2024-05-12",
              "lte": "2024-05-18"
            }
          }
        },
        {
          "term": {
            "profile_info.current_company_industry": {
              "value": "Information Technology and Services"
            }
          }
        }
      ]
    }
  }
}

​
Search by Location and Past Experience

Retrieve profiles of people located in the United States who previously held a product-related role at Google. This query uses a nested query to access past experiences and excludes current roles with the must_not clause. 
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "profile_info.location_country": {
              "value": "united states"
            }
          }
        },
        {
          "nested": {
            "path": "profile_info.experience",
            "query": {
              "bool": {
                "must": [
                  {
                    "match": {
                      "profile_info.experience.company.name": {
                        "query": "Google"
                      }
                    }
                  },
                  {
                    "match": {
                      "profile_info.experience.title.name": {
                        "query": "Product"
                      }
                    }
                  },
                  {
                    "bool": {
                      "must_not": [
                        {
                          "exists": {
                            "field": "profile_info.experience.is_current"
                          }
                        }
                      ]
                    }
                  }
                ]
              }
            }
          }
        }
      ]
    }
  }
}

​
Search by Company Name in Work Experience

Retrieve profiles of people with current or past experience at Google. This query uses a nested query to match work history by company name. 
{
  "query": {
    "nested": {
      "path": "profile_info.experience",
      "query": {
        "match": {
          "profile_info.experience.company.name.raw": {
            "query": "Google"
          }
        }
      }
    }
  }
}

​
Search by Company Name in Past Experience

Retrieve profiles of people who have worked at Google in the past but are not currently employed there. This query uses a nested query to search for past experience at Google and a must_not clause to exclude current employment at the company. 
{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "profile_info.experience",
            "query": {
              "match": {
                "profile_info.experience.company.name.raw": {
                  "query": "Google"
                }
              }
            }
          }
        }
      ],
      "must_not": [
        {
          "match": {
            "profile_info.job_company_name.raw": {
              "query": "Google"
            }
          }
        }
      ]
    }
  }
}
This query uses a nested query to search for work history at Google and a must_not clause to filter out current employees based on the “is_current” field, which is available only if the experience is current. 
{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "profile_info.experience",
            "query": {
              "match": {
                "profile_info.experience.company.name.raw": {
                  "query": "Google"
                }
              }
            }
          }
        }
      ],
      "must_not": [
        {
          "exists": {
            "field": "profile_info.experience.is_current"
          }
        }
      ]
    }
  }
}

​
Search for Profiles with Recent Job Changes

This query retrieves profiles with newly updated job roles. The current_job_updated_at field is used to filter profiles based on a specified time range. The date in the range filter can be adjusted to target job changes relevant to the specific use case. 
{
  "query": {
    "bool": {
      "filter": [
        {
          "range": {
            "profile_info.current_job_updated_at": {
              "gte": "2025-06-01"
            }
          }
        }
      ]
    }
  }
}