> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getcollate.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Using Advanced Search

> Use advanced search and filtering to discover data across sources, owners, and business domains with high precision.

# Using Advanced Search

Advanced search gives you precise control over data discovery by letting you build multi-condition queries through a visual query builder—no syntax knowledge needed.

Instead of scrolling through all assets or relying on keyword search, filter by ownership, classification, location, and structure at once, then combine conditions with AND/OR logic to match exactly the assets you're looking for.

## How to Use Advanced Search

To use the advanced search for building complex queries, perform the following steps:

1. On the left navigation pane, select **Explore** and then click **Tools** > **Advanced Search**.
   <img src="https://mintcdn.com/collatedocs/LF_S_T5ZCzMKQFLu/public/images/how-to-guides/discovery/adv1.png?fit=max&auto=format&n=LF_S_T5ZCzMKQFLu&q=85&s=20da04ea9aab1f520d8c77f06819c893" alt="Advanced Search" width="2980" height="1096" data-path="public/images/how-to-guides/discovery/adv1.png" />

2. In the query builder, do the following to add one or more conditions:
   1. In the **Field** field, select what to search by such as **Deleted**, **Owner**, **Tags**, **Tier**, **Service**, **Database**, **Database Schema**, and others.
   2. Select an **Operator** for your query. This defines how search field matches. These are some common operators, but they vary based on the selected Field: **Equal to**, **Not equal to**, **Any in**, **Not in**, **Contains**, and **Does not contain**.
   3. In the **Criteria** field, enter the value to match against.
   <img src="https://mintcdn.com/collatedocs/oEleGtr0FD9qhm-A/public/images/how-to-guides/discovery/adv2.png?fit=max&auto=format&n=oEleGtr0FD9qhm-A&q=85&s=f0030b416c5865ac58eb702042e5cef3" alt="Add Complex Queries using Advanced Search" width="2943" height="1424" data-path="public/images/how-to-guides/discovery/adv2.png" />

3. (Optional) Click **Add** to add multiple conditions and group the conditions together. Repeat step 2 for each condition.
   * Select AND to match assets that meet all conditions, or OR to match assets that meet at least one.

4. Click **Apply**.

### Example

To find all database assets that don't include "dim" in their name and are owned by either "admin" or "admin user", follow these steps:

1. Click **Tools** > **Advanced Search** and add the first condition group for the Owner filter:

   * Set **Field** to `Owner`, **Operator** to `==`, and **Criteria** to `admin`.
   * Click **Add** within the same group to add a second condition. Set **Field** to `Owner`, **Operator** to `==`, and **Criteria** to `admin user`.
   * Set the group operator to **OR** so assets owned by either person are matched.

   <img src="https://mintcdn.com/collatedocs/gOlIqRL0-A_1WL67/public/images/how-to-guides/discovery/adv6.png?fit=max&auto=format&n=gOlIqRL0-A_1WL67&q=85&s=8e8bb6c14e1b8b5a982d8a620b489906" alt="Grouped conditions based on asset owner" width="2164" height="930" data-path="public/images/how-to-guides/discovery/adv6.png" />

2. Click **Add** below the first condition group to create a second condition group for the Name filter. Set **Field** to `Name`, **Operator** to `Not contains`, and **Criteria** to `dim`.

   <img src="https://mintcdn.com/collatedocs/gOlIqRL0-A_1WL67/public/images/how-to-guides/discovery/adv7.png?fit=max&auto=format&n=gOlIqRL0-A_1WL67&q=85&s=16c0ddfb774fad805be232e4e6b30c83" alt="Advanced search conditions configured" width="2164" height="1208" data-path="public/images/how-to-guides/discovery/adv7.png" />

3. Set the group operator between the two groups to **AND** so both conditions must be fulfilled.

4. Click **Apply**.

**Result**: The results should match the following screen.

<img src="https://mintcdn.com/collatedocs/gOlIqRL0-A_1WL67/public/images/how-to-guides/discovery/adv5.png?fit=max&auto=format&n=gOlIqRL0-A_1WL67&q=85&s=01fcd8451c6354700ff85beba866365d" alt="Advanced search results" width="2998" height="1582" data-path="public/images/how-to-guides/discovery/adv5.png" />

<Tip>
  **Custom Properties in Elasticsearch Search**

  Elasticsearch doesn't support custom properties in these formats:

  * **Time**
  * **DateTime**
  * Any date formats other than `yyyy-MM-dd`

  Make sure custom properties use a supported format before using them as search criteria.
</Tip>
