Filter operator reference

refer to this table to understand different filter operators you can use to further refine your data operator definition example use case contains returns results that contain the value you specify but which might additionally contain other values searching for all properties on a specific street street address contains justin lane does not contain returns results that does not contain the value you specify but which might additionally contain other values searching for all properties excluding those on a specific street street address does not contain justin lane exactly matches returns exact matches only searching for a property using a specific id archipelago id exactly matches 1234567 does not match returns all results that do not exactly match the value you specify searching for all properties outside of new york, including properties outside the united states state not exactly matches new york includes returns results that include multiple items use "," to add additional values searching for properties in new york and california state includes new york, california less or equal returns results less than or equal to the value you specify searching for properties with under 1 million usd in tiv total insured value less or equal 1,000,000 greater or equal returns results greater or equal to the value you specify searching for properties with a building replacement cost of over 3 million usd building replacement cost greater or equal 3,000,000 between results results between 2 values you specify searching for properties with tiv between 500,000 and 1 million usd in tiv total insured value between 500,000 1,000,000 is empty returns results for which the attribute you specify is empty searching for properties without roofing material information roofing material is empty is not empty returns results for which the attribute you specify is not empty searching for all properties containing information about specific occupancy specific occupancy is not empty archipelago uses the display currency when applying any currency related filters, such as total insured value or contents replacement cost