Mongo db atlas search: create atlas search index on embedded document

Question

For storing categories, I have below schema -

{
    name: String,
    description : String,
    subCategories:[
      { 
          name:String,
          description : String
      }
    ]
}

For searching, need to apply atlas search index on both category name and subcategory name. I tried with the below mappings, it didn't work for subcategory's name and description.

{
  "mappings": {
    "dynamic": false,
    "fields": {
      "name": {
          "analyzer": "lucene.standard",
          "type": "string"
        },
      "description": {
          "analyzer": "lucene.standard",
          "type": "string"
        },
      "subCategory.name": {
          "analyzer": "lucene.standard",
          "type": "string"
      },
      "subCategory.description": {
          "analyzer": "lucene.standard",
          "type": "string"
      }
    }
  }
}

Is there something I am missing in the field mappings?

Bathri Nathan · Accepted Answer · 2021-01-15 14:47:17Z

1

Here is the working code to do Atlas search on document or Object.

mainSubscriber - > object (dataType)

The type of the main subscriber must be a 'document'. Then you can specify the inner field as below.

Refer to the static map example in the documentation for more details https://docs.atlas.mongodb.com/reference/atlas-search/index-definitions#std-label-index-config-example

{
  "mappings": {
    "dynamic": false,
    "fields": {
      "identifier": {
        "analyzer": "lucene.standard",
        "type": "string"
      },
      "mainSubscriber": {
        "fields": {
          "identifier": {
            "analyzer": "lucene.standard",
            "type": "string"
          }
        },
        "type": "document"
      },
      "profileId": {
        "analyzer": "lucene.standard",
        "type": "string"
      }
    }
  }
}

answered Jan 15, 2021 at 14:47

Bathri Nathan

1,2772 gold badges15 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Avani Khabiya · Accepted Answer · 2020-10-09 10:33:40Z

I found answer to this question of mine in this documentation for atlas search :

https://docs.atlas.mongodb.com/reference/atlas-search/index-definitions/

So, what I did referencing this document is, modified my mappings slightly to support what I expect. I was doing it in wrong manner earlier.

{
  "mappings": {
    "dynamic": false,
    "fields": {
      "name": {
          "analyzer": "lucene.standard",
          "type": "string"
        },
      "description": {
          "analyzer": "lucene.standard",
          "type": "string"
        },
      "subCategory": {
        "fields": {
          "name": {
            "analyzer": "lucene.standard",
            "type": "string"
          },
          "description": {
            "analyzer": "lucene.standard",
            "type": "string"
          }
        }
      }
    }
  }
}

Collectives™ on Stack Overflow

Mongo db atlas search: create atlas search index on embedded document

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related