Exact Match Query


  • By default, when making a query that filters by strings, the string comparisons are case-insensitive.

  • Use the exact parameter to perform a search that is case-sensitive.

  • When making a dynamic query with an exact match,
    the auto-index created by the server indexes the text of the document field
    using the default exact analyzer where the casing of the original text is not changed.

  • In this page:


Query with exact match

const employees = await session
     // Make a dynamic query on 'Employees' collection    
    .query({ collection: "Employees" })
     // Query for all documents where 'FirstName' equals 'Robert'
     // Pass 'true' as the 3'rd param for a case-sensitive match
    .whereEquals("FirstName", "Robert", true)
    .all();
from "Employees"
where exact(FirstName == "Robert")

  • Executing the above query will generate the auto-index Auto/Employees/ByExact(FirstName).

  • This auto-index will contain the following two index-fields:

    • FirstName
      Contains terms with text from the indexed document field 'FirstName'.
      Text is lower-cased and not tokenized.

    • exact(FirstName)
      Contain terms with the original text from the indexed document field 'FirstName'.
      Casing is exactly the same as in the original text, and the text is not tokenized.
      Making an exact query targets these terms to find matching documents.

Query with exact match - nested object

const orders = await session
     // Make a dynamic query on 'Orders' collection
    .query({ collection: "Orders" })
     // Query for documents that contain at least one order line with 'Teatime Chocolate Biscuits'
     // Pass 'true' as the 3'rd param for a case-sensitive match
    .whereEquals("Lines.ProductName", "Teatime Chocolate Biscuits", true)
    .all();
from "Orders"
where exact(Lines.ProductName == "Teatime Chocolate Biscuits")

Syntax

// Available overloads:

whereEquals(fieldName, value);
whereEquals(fieldName, value, exact);

whereNotEquals(fieldName, value);
whereNotEquals(fieldName, value, exact);
Parameter Type Description
fieldName string Name of field in which to search
value any The value searched for
exact boolean false - search is case-insensitive
true - search is case-sensitive