搜索索引属性 mongodb 在 laravel 升级后未返回任何结果

Question

最近我将Laravel从5.5升级到6。现在，当我执行下面的查询时，它没有返回在 5.5 上返回的结果。我正在使用 JensSegers mongodb 软件包。Asset_id已编入索引

这是我的方法。

public function show($id)
{
return response()->json(Asset::where('asset_id', $id)->get());
}

我的收藏如下所示：

{
"_id": {
"$oid": "5b28b21a943ee732820286be"
},
"asset_id": {
"$oid": "5b28b202943ee732820282f3"
},
"parent_asset_id": {
"$oid": "5b28b21a943ee732820286bd"
},
"updated_by": 1,
"updated_at": {
"$date": "2019-08-12T22:12:10.000Z"
},
"created_by": 1,
"created_at": {
"$date": "2018-06-19T07:34:50.000Z"
},
"document_ids": [
"5b28b2c9943ee73282029a35",
"5b28b2c9943ee73282029a37",
"5b28b2ca943ee73282029a39",
"5b28b2ca943ee73282029a3b",
"5b28b2ca943ee73282029a3d",
"5b28b2cb943ee73282029a3f"
],
"workOrderAssets": [
"5b28b203943ee73282028313:1",
"5b28b209943ee732820283fd:1",
"5b28b203943ee7328202830f:1",
"5b28b203943ee7328202830d:1",
"5b28b203943ee7328202830b:1",
"5b28b203943ee73282028309:1",
"5b28b203943ee73282028307:1",
"5b28b203943ee732820282f5:1",
"5b28b202943ee732820282f3:1"
],
"workOrderIds": [
1
]
}

Answer 1

必须在 objectId 上搜索并使用 MongoDB\BSON\ObjectId;