> For the complete documentation index, see [llms.txt](https://docs.realmjoin.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.realmjoin.com/analyze-and-export/advanced-search.md).

# Advanced Search

Search and filter the Users, Groups, Devices and Packages tables with column filters and operators

Advanced Search runs your search against a cached copy of the table's data held by the RealmJoin Portal instead of querying Microsoft Graph for every search. This keeps searches fast in tenants with many objects and allows column filters, operators and sorting across the whole list.

{% hint style="info" %}
Advanced Search is available in the Users, Groups, Devices and Packages tables. Operators and all searchable columns are described in [Advanced Search Syntax](https://docs.realmjoin.com/analyze-and-export/advanced-search/advanced-search-syntax.md).
{% endhint %}

Tables can be searched using the *basic* or the *advanced* search feature.

{% hint style="info" %} <mark style="background-color:yellow;">**All searches have to be confirmed by either using the**</mark><mark style="background-color:yellow;">**&#x20;**</mark>*<mark style="background-color:yellow;">**enter key**</mark>*<mark style="background-color:yellow;">**&#x20;**</mark><mark style="background-color:yellow;">**or the**</mark> <img src="https://2868468309-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MkrcM7cKOpXKri1kVrh%2Fuploads%2FHli0RfKsBzt7a91EpdOv%2Fimage.png?alt=media&amp;token=eadfefc7-d7b2-485c-9902-6fa6c94f8ee4" alt="" data-size="line"> <mark style="background-color:yellow;">**symbol.**</mark>
{% endhint %}

### Basic Search

Basic Search uses the Graph API to directly query tenant data, providing real-time results.

Basic Search is always available as a fallback when Advanced Search is not. It also appears during the initial loading of the cached table, allowing users to search immediately—even before the cache is fully built.

### Advanced Search

Advanced Search splits text into words (tokens) and matches the beginning of each word. Unicode characters like Ø are supported. This enables partial name searches, so a query like "Ma Mu" can locate a user named "Maren Müller".

Additionally, information not displayed in the table is also searchable, like the UPN or, with a column-specific search, the postal code.

<figure><img src="https://2868468309-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MkrcM7cKOpXKri1kVrh%2Fuploads%2Fgit-blob-76bb66e738c2cf9cbeed656be54f23b2772d5700%2Fadvanced-search-users-column-filter.png?alt=media" alt="Users table filtered with the Advanced Search query dept:Sales"><figcaption><p>Users table filtered with the column filter <code>dept:Sales</code></p></figcaption></figure>

{% hint style="warning" %}
Please make sure to only use the "Reload-Button" in the top right corner if you are missing very recently added information from Entra / Intune.
{% endhint %}

### FAQ

#### How often is the data cached?

The table is cached on a schedule, currently set to 1 hour.

#### Can I refresh the data manually?

In the top right corner of each table, there's a button to refresh the cached data.

#### Can other users use my refreshed data?

The table is available for all users in the same RealmJoin portal instance. Thus, a triggered rebuild will do so for all those users.

#### What is a RealmJoin portal instance?

The RealmJoin portal has three different instances for load balancing and redundancy reasons.

#### How long will a rebuild/refresh of the advanced search take?

The rebuild time depends on the size of the tenant and the number of objects. It is not uncommon, that the rebuild might take several minutes. During the rebuild, only the basic search is available. All data is then queried directly via Graph, thus reducing the capabilities in filtering and speed.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.realmjoin.com/analyze-and-export/advanced-search.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
