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.
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 |
exactly matches | 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 |
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. To learn more about how currencies work in Archipelago, refer to the local currencies help.