将列表传递给嵌套在elemMatch中的MongoDb查询

对于以下文档结构-

{
    "_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);
iCMS 回答:将列表传递给嵌套在elemMatch中的MongoDb查询

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/1616971.html

大家都在问