Filter operator reference
Refer to this table to understand different filter operators you can use to further refine your data.
If you're filtering properties using the Archipelago API, refer to API Conventions to learn about filtering programmatically.
Example use case
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
Returns exact matches only.
Searching for a property using a specific ID: Archipelago ID exactly matches 1234567
not exactly matches
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
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
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. To learn more about how currencies work in Archipelago, refer to the local currencies help.