对于以下文档结构-
{
"_id" : ObjectId("5cf25412326c3f4f26df03ae"),"restaurantId" : "18471268","items" : [
{
"itemId" : "F4QJAMWKHY","name" : "Seafood Grill Squared Burger","imageUrl" : "","price" : 236,"attributes" : [
"Spicy","Gravy"
]
},{
"itemId" : "MNA8IHX74Q","name" : "Crumb Fried Fish Burger","price" : 265,"attributes" : [
"Sweet","Sweet"
]
}
]
}
...
我想基于我作为List ()传递的itemId的列表获取所有菜单。
以下查询似乎无效。
@Query(value = "{ 'items' : {$elemMatch : {'itemId' : {$in : ?0}}}}")
List<MenuEntity> findMenuByItemId(List<String> itemIds);