How to use equals operator for atlas search in mongodb-driver-core Java library

williamwjs · 2023-03-14T02:46:39.204Z

I am using mongodb-driver-core 4.9.0, and noticed that the library does not offer many operators, like equals as mentioned in https://www.mongodb.com/docs/atlas/atlas-search/equals/

May I ask if I am missing anything here, or I would have to use SearchOperator.of(...) here? If so, I tried to pass in the equals Bson document, but it does not work in my query.

Looks forwards to your help! Thank you!

Jeffrey_Yemin · 2023-03-20T16:31:20.735Z

Yeah, it doesn’t look like there is no builder for equals. If you reply with the code you tried for using of, along with the expect and actual output, we can try to figure out what’s going wrong.

williamwjs · 2023-03-20T18:49:40.688Z

Hi Jeffrey, thank you for your reply!

I am trying to do something like:

  private static final String EQUAL_CLAUSE = """
      {
        "equals": {
          "path": "myFlag",
          "value": true
        }
      }
      """;

      filterOperators.add(SearchOperator.of(Document.parse(EQUAL_CLAUSE)));
      CompoundSearchOperator compoundSearchOperator = SearchOperator.compound().filter(filterOperators);
      if (!mustOperators.isEmpty()) {
        compoundSearchOperator = compoundSearchOperator.must(mustOperators);
      }
      if (!shouldOperators.isEmpty()) {
        compoundSearchOperator = compoundSearchOperator.should(shouldOperators);
      }
      aggregates.add(Aggregates.search(compoundSearchOperator));

However, it would yield with no results for me.

Jeffrey_Yemin · 2023-03-20T21:06:16.706Z

It sounds like the Java driver part is working ok, but the query just doesn’t match. You might want to look in logs to confirm that the query is generated as you expect, and then check your data against the query, and re-read the docs, to see why you’re not getting results.

Jeff

williamwjs · 2023-03-21T01:04:29.605Z

Found the issue in the index configuration. all good now.

Thank you!

Eason · 2023-08-17T13:36:20.892Z

Hey, may I ask how do you fix the issue? What is wrong with the index configuration?
I am facing the same issue

Eason · 2023-08-17T13:46:57.010Z

And indeed there is no builder for equals see here: SearchOperator (driver-core 4.10.0 API) (mongodb.github.io)

williamwjs · 2023-08-17T18:12:59.971Z

Sorry, tbh, I cannot remember what I did…
I think maybe I initially did not configure to use lucene.standard as the Analyzer. Would you check that? Or did you turn on the dynamic mapping?

(Perhaps pasting your index mapping JSON here would be helpful to identify the cause)

John_Bonds1 · 2025-03-03T19:46:33.829Z

FWIW here is a link to the PR that was merged that will include the equals operator. There are more operators coming soon to the library.

github.com/mongodb/mongo-java-driver

Add equals operator to Atlas Search

mongodb:main ← joykim1005:JAVA-5729

opened 07:17PM - 14 Jan 25 UTC

joykim1005

+342 -3

### Ticket [JAVA-5729](https://jira.mongodb.org/browse/JAVA-5729) ### Descri…ption There are several Atlas Search query operators that are not implemented with first class support in the Java driver. This PR adds the `equals` operator to Atlas Search. ### Testing - [X] ran `./gradlew check` - [X] ran `atlas-search-test` on Evergreen - [X] ran `SearchOperatorTest` - [ ] ran all Evergreen patch