Hi community i-m new in atlas db not in mongo how can i create a query for documents like this…
my mapping index is dynamically true.
I have a collection of this documents
{
"features": [
{
"feature_type": "INSURANCE_HOME",
"coverage_value": "",
"feature_name": "Vivienda de uso Permanente",
"feature_group": "House Use Type"
},
{
"feature_type": "INSURANCE_HOME",
"coverage_value": "",
"feature_name": "Apartamento PB o Primer Piso",
"feature_group": "House Positions"
},
{
"feature_type": "INSURANCE_HOME",
"coverage_value": "",
"feature_name": "Techo liviano",
"feature_group": "House Roofs"
},
{
"feature_type": "INSURANCE_HOME",
"coverage_value": "",
"feature_name": "Steel framing",
"feature_group": "House Walls"
},
{
"feature_type": "INSURANCE_HOME",
"coverage_value": "",
"feature_name": "Vivienda Principal",
"feature_group": "House Types"
},
{
"feature_type": "INSURANCE_HOME",
"coverage_value": "",
"feature_name": "A primer Riesgo Absoluto",
"feature_group": "House Contract Type"
}
],
"coverages": [
{
"feature_type": "INSURANCE_HOME_COVERAGE",
"coverage_value": 10000,
"feature_name": "Cobertura de robo (1)",
"feature_group": "House Coverage"
},
{
"feature_type": "INSURANCE_HOME_COVERAGE",
"coverage_value": 30000,
"feature_name": "Cobertura de incendio del contenido del inmueble",
"feature_group": "House Coverage"
},
{
"feature_type": "INSURANCE_HOME_COVERAGE",
"coverage_value": 100000,
"feature_name": "Cobertura de incendio",
"feature_group": "House Coverage"
}
],
"zip_code": 15000,
"price": 416
}
for example i need the documents with a set of features, this features need to be searched by features.feature_group, features.feature_name with a coverages.feature_name equals to a string and a coverage.coverage_value equal to other value and determined by zipcode.
using in my document example:
i need document with:
“features”: [
{
“feature_name”: “Vivienda de uso Permanente”,
“feature_group”: “House Use Type”
}
and
{
“feature_name”: “Apartamento PB o Primer Piso”,
“feature_group”: “House Positions”
}
and
{
“feature_name”: “Techo liviano”,
“feature_group”: “House Roofs”
},
and
{
“feature_name”: “Steel framing”,
“feature_group”: “House Walls”
}
and
{
“feature_name”: “Vivienda Principal”,
“feature_group”: “House Types”
}
and
{
“feature_name”: “A primer Riesgo Absoluto”,
“feature_group”: “House Contract Type”
}
and
“coverages”: [
{
“coverage_value”: near 10000 with pivot :5000
“feature_name”: “Cobertura de robo (1)”,
}
and
{
“coverage_value”: near 100000 with pivot 50000
“feature_name”: “Cobertura de incendio”,
}
],
and
“zip_code”: 15000,
}
Could you helpme with this?
Thanks a lot.