website logo
User Guide
API Documentation
Navigate through spaces
User Guide
API Documentation
⌘K
Overview
Get started with Archipelago
Access the platform
Control market access to a stream
Share a stream
Upload SOVs through your submission dashboard
Key terms
Interact with stream data
Navigate your organizations
View data
Filter data
Gain insights from data
Convert local currencies
Export data
Manage documents
Upload documents
View documents
View information from documents
Manage properties
Upload property data
Add properties
Edit properties
Dispose of properties
Manage losses
Upload loss data
View losses
Add losses
Edit losses
Enrich your data
How enrichment works
Docs powered by archbee 
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 the local currencies help.



Updated 03 Mar 2023
UP NEXT
Gain insights from data
Docs powered by archbee 

© 2022 Archipelago Analytics, Inc. All rights reserved.