Advanced Search
Experience nearly load-free access to your data
From May 9th, RealmJoin introduces a revamped search mechanism that enables real-time access to tenant data. This enhancement ensures efficient performance even for tenants with a large volume of user, device, and group objects.
Tables can be searched using the basic or the advanced search feature.
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
RealmJoin's advanced search feature uses caching and tokenization, making searches fast and reliable, and supports Unicode characters like Ø. This tokenization 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 post-codes or UPN.

Advanced Search Syntax Overview
Advanced Search allows querying across available table values using a flexible and powerful syntax. Below are the key features and rules:
Tokenized Search: Search terms are automatically tokenized to improve matching accuracy. For example, typing
lu sk
will match names like Luke Skywalker. The search always uses a starts-with approach rather than a full-text or "contains" search. This means a search forwalk
would not return Skywalker.Logical AND: All filters are combined using logical AND. Every condition must be met. Example:
Luke Skywalker country:france
searches for Luke Skywalker where the country starts with "france".Column-specific Search: Use
column:
to search within a specific column. Example:country:france
searches for entries where the country starts with "france".Operators:
:
→ startsWith search Example:name:jo
matches "John", "Joanna", etc.=
→ equals search Example:city=Stuttgart
matches exactly "Stuttgart"!=
or!:
→ negation Example:city!=Stuttgart
orcity!:Stuttgart
excludes "Suttgart"
Special Behavior:
Umlaut substitution: Umlauts are normalized (e.g., Björn can be found by searching for Bjorn).
Unicode support: Unicode characters are supported in search terms.
Brackets () are ignored in startsWith searches.
Empty value search:
zip:""
searches for empty valueszip:
searches for any value
Supported Columns:
Aliases for column names may exist and are listed in brackets
User table:
name, upn, language (lang), jobtitle (job), city, country, zip (plz), enabled, department (dept)
enabled:
→ acceptstrue
orfalse
(enabled:true
)
Groups table
name
Device table
name, operatingsystem (os), manufacturer (manu), model
Examples
Get all users of a specific department:
department:"Sales Department"
Get all users with job title CEO:
job:CEO
Get all users with job title CEO not in Germany:
job:CEO country!:Germany
Get all users starting with ADM- with an empty department:
name:ADM- department=""
Get all users with postal code 63065:
zip:63065
List all users with specific domain:
domain.com
Get all Windows 11 Version 22H2 devices:
Get all Dell XPS devices:
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 an 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.
Last updated
Was this helpful?