$or

Description: Combines multiple conditions on connectors, returning true/false.

{  
  "refine": {  
    "has_pool_or_chickens": {  
      "$or": [  
        { "hosted_attom_residential_tax_assessor.results[*].poultry_house_flag": { "$eq": true } },  
        { "hosted_attom_residential_tax_assessor.results[*].pool_house_flag": { "$eq": true } }  
      ]  
    }  
  }  
}

$and

Description: Combines multiple conditions on connectors, returning true/false.

{  
  "refine": {  
    "building_requirements": {  
      "$and": [  
        { "housecanary_property.public.number_of_bedrooms": { "$gte": 3 } },  
        { "housecanary_property.public.building_area_sqft": { "$between": [1900, 2700] } }  
      ]  
    }  
  }  
}

$empty

Description: Returns true if the attribute was empty.

{ "experian_business_facts.ticker_symbol": "$empty" }

$nonEmpty

Description: Returns true if the attribute was not empty.

{ "experian_business_facts.ticker_symbol": "$nonEmpty" }

$eq [json]

Description: Returns true if the attribute was not empty and equal to the passed in JSON node.

{ "domain_from_email.host": { "$eq": "demystdata.com" }}

$in [json]

Description: Returns true if the attribute was not empty and was equal to any of the given arguments.

{ "hazardhub_risks_and_enhanced_property2.risks.wildfire.score": { "$in": ["A", "B", "C"] }}

$notIn [json]

Description: Returns true if the attribute was not empty and was not equal to any of the given arguments.

{ "hazardhub_risks_and_enhanced_property2.risks.wildfire.score": {"$notIn": ["D", "E", "F"] }}

$gt json-number

Description: Returns true if the attribute was not empty and > to the passed-in JSON number.

{ "experian_business_facts.employee_size": { "$gt": 75 }}

$gte json-number

Description: Returns true if the attribute was not empty and ≥ to the passed-in JSON number.

{ "experian_business_facts.employee_size": { "$gte": 75 }}

$lt json-number

Description:Returns true if the attribute was not empty and to the passed-in JSON number.

{ "experian_business_facts.employee_size": { "$lt": 20 }}