我在一个项目中使用了一个jensegers/laravel-mongodb库。我有一个集合,其中创建了一个子文档和其他详细信息。现在我必须实现一个搜索查询,以便在集合的子文档中进行搜索。子文档是product_data,我想在它的索引6中搜索它。我想在其中搜索国家名称。我该怎么做。收集的结构如下:
{
"_id": ObjectId("564d32f191c1cb1f087d7c71"),
"userid": "55c487a1083f11aa1b8b4567",
"shopid": "anotherstore",
"postedby": null,
"purpose": "sell",
"cat_ids": [
"TDC00-001-001",
],
"postdate": "2015-11-19",
"desc": "T-SHIRT",
"thumb": "http://test.local/uploads/product_img/prod-8yKsMHC2-1447895652.jpg",
"product_data"▼: {
"1": "2015-11-19",
"2": "anotherstore",
"3": "T-SHIRT",
"4": "1245",
"6": "Styling features include twin needle stitching for neatness and strength on the collar, sleeve and h",
"5": "US",
"6": "US"
}
}
我尝试过一些查询搜索,但没有成功。它们是:
$country=Array(
[0] => Australia
)
$country = Products::whereIn('product_data[6]', $country)->get();
or
$country = Products::where('books', 'elemMatch', array([6] => $country))->get();
如果有人知道,请帮忙。
因为在mongo:中对子文档的查询是这样的
db.products.find({'product_data.6':'US'});
您只需要在代码中重新创建该结构:
$country = 'US';
$queryFilter = ['product_data.6'=>$country];
Products::where($queryFilter)->first(); //or get whatever.
如果你想在一系列国家中搜索,你必须使用whereIn方法
$countries = ['US','SPAIN'];
$results = Products::whereIn('product_data.6',$countries)->get();