I have following data
[
{
"_id": "58fb3b7b78352e228c9e86b5",
"item_id": "xxxxx",
"sku": "D7C-670-A7B",
"price": "40.73",
"categoryname": "TV, film e videogiochi",
"categoryid": 75708,
"__v": 0,
"country": "Italy",
"specifics": {
"NameValueList": [
{
"Name": "MPN",
"Value": "Does Not Apply",
"Source": "ItemSpecific"
},
{
"Name": "EAN",
"Value": "Non applicabile",
"Source": "ItemSpecific"
},
{
"Name": "EAN",
"Value": "Non applicabile"
},
{
"Name": "ISBN",
"Value": "Non applicabile"
}
]
},
"ean": "Non applicabile"
},
{
"_id": "58fb3b7b78352e228c9e86b7",
"price": "13.6",
"categoryname": "Etuis, housses, coques",
"categoryid": 20349,
"__v": 0,
"country": "France",
"specifics": {
"NameValueList": [
{
"Name": "Compatible Marques",
"Value": "Pour Samsung, Apple, pour HTC, pour LG, pour Google",
"Source": "ItemSpecific"
},
{
"Name": "Compatible Modèles",
"Value": "iPhone 5, 5S,5C,6,6S",
"Source": "ItemSpecific"
},
{
"Name": "Design/Finition",
"Value": "Brillant et Mat",
"Source": "ItemSpecific"
},
{
"Name": "Caractéristiques",
"Value": "Étanche, Étui Rigide",
"Source": "ItemSpecific"
},
{
"Name": "MPN",
"Value": "Elephant",
"Source": "ItemSpecific"
},
{
"Name": "Matériau Du Produit",
"Value": "Polycarbonate Plastique",
"Source": "ItemSpecific"
},
{
"Name": "Type :",
"Value": "Fitted Case/Skin",
"Source": "ItemSpecific"
},
{
"Name": "Numéro de pièce fabricant",
"Value": "Elephant",
"Source": "ItemSpecific"
}
]
},
"ean": ""
}]
I wanted to get all the items which has
spicifics.NameValueList.Name = "MPN" && spicifics.NameValueList.Name = "Universal"
I am using $unwind in $aggregate query but its not returning, the expected output.
ebayItems.aggregate([
{$unwind:'$specifics.NameValueList'},
{
$group:{"_id":"$item_id"}
},
{$project:{"_id":1,"HasMPN":{"$cond":{
"if":{"$eq":["$specifics.NameValueList.Name","MPN"]},
"then":"HasMPN",
"else":"NoMPN"
}}}}
]).exec(function(err,item){
if (err) {
res.json(err)
} else {
res.json(item)
}
})
the output for above is always 'NoMPN'. The expected Output for above two fields should be 'HasMPN'.
via DHRUV GUPTA
No comments:
Post a Comment