Edit

OData full-text search functions in Azure AI Search - search.ismatch and search.ismatchscoring

  • Article

Azure AI Search supports full-text search in the context of OData filter expressions via the search.ismatch and search.ismatchscoring functions. These functions allow you to combine full-text search with strict Boolean filtering in ways that are not possible just by using the top-level search parameter of the Search API.

Note

The search.ismatch and search.ismatchscoring functions are only supported in filters in the Search API. They are not supported in the Suggest or Autocomplete APIs.

Syntax

The following EBNF (Extended Backus-Naur Form) defines the grammar of the search.ismatch and search.ismatchscoring functions:

search_is_match_call ::=
    'search.ismatch'('scoring')?'(' search_is_match_parameters ')'

search_is_match_parameters ::=
    string_literal(',' string_literal(',' query_type ',' search_mode)?)?

query_type ::= "'full'" | "'simple'"

search_mode ::= "'any'" | "'all'"

An interactive syntax diagram is also available:

OData syntax diagram for Azure AI Search

Note

See OData expression syntax reference for Azure AI Search for the complete EBNF.

search.ismatch

The search.ismatch function evaluates a full-text search query as a part of a filter expression. The documents that match the search query will be returned in the result set. The following overloads of this function are available:

  • search.ismatch(search)
  • search.ismatch(search, searchFields)
  • search.ismatch(search, searchFields, queryType, searchMode)

The parameters are defined in the following table:

Parameter name Type Description
search Edm.String The search query (in either simple or full Lucene query syntax).
searchFields Edm.String Comma-separated list of searchable fields to search in; defaults to all searchable fields in the index. When using fielded search in the search parameter, the field specifiers in the Lucene query override any fields specified in this parameter.
queryType Edm.String 'simple' or 'full'; defaults to 'simple'. Specifies what query language was used in the search parameter.
searchMode Edm.String 'any' or 'all', defaults to 'any'. Indicates whether any or all of the search terms in the search parameter must be matched in order to count the document as a match. When using the Lucene Boolean operators in the search parameter, they will take precedence over this parameter.

All the above parameters are equivalent to the corresponding search request parameters in the Search API.

The search.ismatch function returns a value of type Edm.Boolean, which allows you to compose it with other filter sub-expressions using the Boolean logical operators.

Note

Azure AI Search does not support using search.ismatch or search.ismatchscoring inside lambda expressions. This means it is not possible to write filters over collections of objects that can correlate full-text search matches with strict filter matches on the same object. For more details on this limitation as well as examples, see Troubleshooting collection filters in Azure AI Search. For more in-depth information on why this limitation exists, see Understanding collection filters in Azure AI Search.

search.ismatchscoring

The search.ismatchscoring function, like the search.ismatch function, returns true for documents that match the full-text search query passed as a parameter. The difference between them is that the relevance score of documents matching the search.ismatchscoring query will contribute to the overall document score, while in the case of search.ismatch, the document score won't be changed. The following overloads of this function are available with parameters identical to those of search.ismatch:

  • search.ismatchscoring(search)
  • search.ismatchscoring(search, searchFields)
  • search.ismatchscoring(search, searchFields, queryType, searchMode)

Both the search.ismatch and search.ismatchscoring functions can be used in the same filter expression.

Examples

Find documents with the word "waterfront". This filter query is identical to a search request with search=waterfront.

    search.ismatchscoring('waterfront')

Find documents with the word "hostel" and rating greater or equal to 4, or documents with the word "motel" and rating equal to 5. Note, this request could not be expressed without the search.ismatchscoring function.

    search.ismatchscoring('hostel') and Rating ge 4 or search.ismatchscoring('motel') and Rating eq 5

Find documents without the word "luxury".

    not search.ismatch('luxury')

Find documents with the phrase "ocean view" or rating equal to 5. The search.ismatchscoring query will be executed only against fields HotelName and Rooms/Description.

Documents that matched only the second clause of the disjunction will be returned too -- hotels with Rating equal to 5. To make it clear that those documents didn't match any of the scored parts of the expression, they will be returned with score equal to zero.

    search.ismatchscoring('"ocean view"', 'Rooms/Description,HotelName') or Rating eq 5

Find documents where the terms "hotel" and "airport" are within 5 words from each other in the description of the hotel, and where smoking is not allowed in at least some of the rooms. This query uses the full Lucene query language.

    search.ismatch('"hotel airport"~5', 'Description', 'full', 'any') and Rooms/any(room: not room/SmokingAllowed)

Find documents that have a word that starts with the letters "lux" in the Description field. This query uses prefix search in combination with search.ismatch.

    search.ismatch('lux*', 'Description')

Next steps