Atlas Search Autocomplete on an array of object

Shadoweb_EB · 2021-05-23T10:05:23.195Z

I’m facing the same issue. It works on a simple nested document, but not for an array of nested documents. It works with “text” instead of “autocomplete” but that requires the exact string which is not really possible.

Nicolas_Sandoz · 2021-05-26T08:21:30.021Z

Hello everybody, same issue here Somebody find a solution ? Please help, because this is very impactful. Thanks in advance.

Nicolas_Sandoz · 2021-05-27T18:58:58.889Z

Please Karen, help us with this topic

Karen_Huaulme · 2021-05-27T19:53:39.088Z

Hello, everyone. Thank you so much for the code and index definitions. You are correct that this does not currently work, but this is a particular use case we are actively working on right now. @Shadoweb_EB, you could include a fuzzy object into the text- but you would have to get close to the end of the string for this to work.
"fuzzy": { "maxEdits": 2 }
So this is not exactly what you need.
Hopefully, we will have a resolution soon.

Omer_Yaari · 2021-05-31T10:47:19.408Z

How much time until it will be supported?

Nicolas_Sandoz · 2021-06-23T12:44:57.965Z

Hello Karen, Thanks for your answer. Do you think it’s going to take a long time ? Do you have approximatively an idea on how much time ? Many of us are waiting for a solution to this problem. Also, could you posted here once a solution has been found ? Thank you in advance for your help.

Karen_Huaulme · 2021-06-24T15:54:20.989Z

Hello. It should be done this quarter. Please vote on the issue on feedback.mongodb.com, you should be notified when it is worked out. Allow autocomplete search on multiple fields using a wildcard path or by specifying multiple fields in the path – MongoDB Feedback Engine

Karen

Kellen_Busby · 2021-11-19T23:04:54.339Z

Hi, I voted on the linked enhancement request. There aren’t any updates on that ticket, though. Can you provide an update on progress? I would love this feature. Thanks!

Warren_Wonderhaus · 2022-02-07T19:51:09.967Z

Yes, and it’d be great if this limitation were mentioned in the docs. I losta bunch of time on this today for nothing. Thanks.

Warren_Wonderhaus · 2022-02-10T13:32:05.589Z

Actually I was wrong it is in the docs, kind of. According to the index definition page (https://docs.atlas.mongodb.com/atlas-search/index-definitions/#array), you can’t even use autocomplete for an array of strings, let alone an array of docs:

“You can’t use the autocomplete type to index fields whose value is an array of strings.”

FWIW, I’ve got an array of ‘tags’ for my use case. Attempting to refactor it as a string that can be searched using autocomplete instead.

Alexander_Wieland · 2022-08-18T10:34:26.287Z

Hi, when is it planned to be possible to use autocomplete on array of objects?
Thanks in advance

V_C1 · 2022-10-13T15:43:46.172Z

Hi.
When do you plan to implement autocomplete on arrays?
Thank you.

Jason_Tran · 2022-10-14T03:50:36.001Z

Hi @Alexander_Wieland and @V_C1 - Welcome to the community.

At this point in time as per the autocomplete documentation:

You can’t use the autocomplete type to index fields whose value is an array of strings.
You can use the autocomplete type to index string fields inside an array of documents indexed as the embeddedDocuments type

Alex, I believe the second dot point is related to your question. V_C1, if this is also the case for you too (array of documents), then please refer to the docs link. If not, I would create a new topic and advise your use case details including sample documents.

Regards,
Jason

V_C1 · 2022-10-14T06:24:55.266Z

Hi Jason.
What is the point to index something if one cannot search for it?
Are there any plans to implement such a search?
Thank you.

Robin_FERRE · 2022-10-14T09:09:44.302Z

Hi Jason, thanks for your response. Since I had a hard time making it, here is an implementation of this use case that works for me (it might help others):

The search index JSON on mongo Atlas

{
  "mappings": {
    "dynamic": false,
    "fields": {
      "name": {
        "type": "autocomplete"
      },
      "roles": {
        "dynamic": true,
        "type": "embeddedDocuments",
        "fields": {
          "externalId": {
            "type": "autocomplete"
          },
          "phone": {
            "type": "autocomplete"
          }
        }
      }
    }
  }
}

The query

db.entities.aggregate([
  {
    "$search": {
      "compound": {
        "should": [
          {
            "autocomplete": {
              "query": "search query input",
              "path": "name"
            }
          },
          {
            "embeddedDocument": {
              "path": "roles",
              "operator": {
                "compound": {
                  "should": [
                    {
                      "autocomplete": {
                        "path": "roles.externalId",
                        "query": "search query input"
                      }
                    },
                    {
                      "autocomplete": {
                        "path": "roles.phone",
                        "query": "search query input"
                      }
                    }
                  ]
                }
              }
            }
          }
        ]
      }
    }
  },
  {
    $addFields: {
      "score": { $meta: "searchScore" }
    }
  }])

V_C1 · 2022-10-14T12:39:42.161Z

Thank you Robin.
This the solution.

JBIT · 2023-05-10T13:08:52.998Z

@Robin_FERRE That works, thanks!

There is still one problem with autocomplete on embeddedDocuments. It doesn’t support highlights.

Does anyone know how to determine which of the fields contains queried phrase?

@Karen_Huaulme Are there any plans on supporting highlights in embedded documents?

Also, I’ll mention one weird thing. Autocomplete worked for me when I indexed documents in an array, just as document, not embeddedDocuments. Unfortunately, the results are incorrect. It works like there was a fuzzy search applied.

JBIT · 2023-10-26T07:28:22.662Z

If anyone is interested, here’s a suggestion to add a embeddedDocuments highlights support:

MongoDB Feedback Engine

Support highlights in embeddedDocuments autocomplete

According to docs, currently it is not possible to get highlights inside embeddedDocuments, in autocomplete requests. This makes array of objects (embeddedDocuments) autocomplete unusable in our use case.

N171155_GUNTURI_BHAVYASRI · 2023-11-25T17:44:35.972Z

Does anyone know how to auto complete an object . but i have so many fields in that object and also the fields in that object vary from one document to another . So I want to use wildcard .
Finally , I need an autocomplete with wildcard . please help me !

fonts_bunch · 2023-11-26T00:13:06.648Z

How much time until it will be supported.?