Matching with Negations
Negations enable you to search for items that do not have exact matching. In this scenario, check for inequality with the !=
operator.
FOR review IN sample_view
SEARCH ANALYZER(review.Property_Name != "Rhodes Hotel", "identity")
RETURN review.Property_Name
The returned results:
Property_Name |
---|
Apex London Wall Hotel |
Corinthia Hotel London |
The Savoy |
... |
You can expand this to include multiple values. Use the logical OR
operator, IN
operator, or bind parameters.
For example, these queries all return the same result:
FOR review IN sample_view
SEARCH ANALYZER(review.Property_Name == "Apex London Wall Hotel" OR review.Property_Name == "Corinthia Hotel London", "identity")
RETURN review.Property_Name
FOR review IN sample_view
SEARCH ANALYZER(review.Property_Name IN ["Apex London Wall Hotel", "Corinthia Hotel London"], "identity")
RETURN review.Property_Name
This example uses a bind parameter (@hotel_names
):
FOR review IN sample_view
SEARCH ANALYZER(review.Property_Name IN @hotel_names, "identity")
RETURN review.Property_Name
These examples query a list of items starting with:
Property_Name |
---|
Apex London Wall Hotel |
Corinthia Hotel London |
Corinthia Hotel London |
Apex London Wall Hotel |
... |