2min

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 our local currencies help.



Updated 03 Jun 2022
Did this page help you?
Yes
No

© 2022 Archipelago Analytics, Inc. All rights reserved.