Filter by Field Presence
-
To filter documents by whether they contain a particular field, use the LINQ extension method
whereExists()
accessible from the Document Query. -
If a document doesn't contain the specified field, it is excluded from the query results.
-
In this page:
Syntax
IDocumentQuery<T> whereExists(String fieldName);
Parameters | Type | Description |
---|---|---|
fieldName | String |
The name or path to the field you want to filter by |
Examples
Filter by Field Name
List<Employee> results = session
.advanced()
.documentQuery(Employee.class)
.whereExists("FirstName")
.toList();
from Employees
where exists("FirstName")
Filter by the Path to a Field
List<Employee> results = session
.advanced()
.documentQuery(Employee.class)
.whereExists("Address.Location.Latitude")
.toList();
from Employees
where exists("Address.Location.Latitude")