You are currently browsing legacy 4.1 version of documentation. Click here to switch to the newest 4.2 version.

We can help you with migration to the latest RavenDB

Contact Us Now
see on GitHub

Session: Querying: How to Use Regex

To return only documents that match a given regular expression, use the regex() method which enables RavenDB to perform server-side pattern matching queries.

The supplied regular expression must be .NET compatible.

Example

// loads all products, which name
// starts with 'N' or 'A'
const products = await session.query({ collection: "Products" })
    .whereRegex("name", "^[NA]")
    .all();
from Products 
where regex(name, '^[NA]')