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

Working with Data Drivers & ODMs
,
#1

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!

#2

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.

#3

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.

#4

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

#5

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

Thank you!

#6

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

#7

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

#8

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)