查询Spring数据mongodb中对象列表的嵌套Map

w6mmgewl 于 2023-01-04 发布在 Go

关注(0)|答案(1)|浏览(129)

bounty将在7天后过期。回答此问题可获得+100的声望奖励。Sandip Nepal正在寻找规范答案。

我有一个实体：

package com.gl.successPaths.user.entity;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.data.annotation.Id;
import org.springframework.data.annotation.Transient;
import org.springframework.data.mongodb.core.mapping.Document;

import com.gl.successPaths.interests.model.InterestArea;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
@Document(collection = "user")

public class User {

    @Transient
    public static final String SEQUENCE_NAME = "users_sequence";
    @Id
    private long userId;
    private String name;
    private String email;
    private String profileUrl;
    private String profileImgUrl;
    private String contactNumber;
    private String designation;
    private String band;
    private long employeeId;
    private String experience;
    private String department;
    private boolean isIsNotificationActive;
    private Map<String, List<InterestArea>> interestAreas = new HashMap<>();
}

和另一个类InterestArea.java作为

public class InterestArea {
    private long interestAreaId;
    private String interestAreaName;
    private boolean isIsSelected;
}

其json为：

{
"myMentees": [],
"interestAreas": {
    "Activities & Interests": [
        {
            "interestAreaName": "Bike Riding",
            "isSelected": false,
            "interestAreaId": 17
        },
        {
            "interestAreaName": "Cycling",
            "isSelected": false,
            "interestAreaId": 18
        },
        {
            "interestAreaName": "Running",
            "isSelected": false,
            "interestAreaId": 19
        },
        {
            "interestAreaName": "Cooking",
            "isSelected": false,
            "interestAreaId": 20
        },
        {
            "interestAreaName": "Photography",
            "isSelected": false,
            "interestAreaId": 21
        },
        {
            "interestAreaName": "Yoga/Meditation",
            "isSelected": false,
            "interestAreaId": 22
        }
    ],
    "Wellness": [
        {
            "interestAreaName": "Financial Planning",
            "isSelected": false,
            "interestAreaId": 11
        },
        {
            "interestAreaName": "Health",
            "isSelected": false,
            "interestAreaId": 12
        },
        {
            "interestAreaName": "Motivation",
            "isSelected": false,
            "interestAreaId": 13
        },
        {
            "interestAreaName": "Work life balance",
            "isSelected": false,
            "interestAreaId": 14
        }
    ],
    "Social Impact": [
        {
            "interestAreaName": "Educate to Empower",
            "isSelected": false,
            "interestAreaId": 15
        },
        {
            "interestAreaName": "Environment Drive",
            "isSelected": false,
            "interestAreaId": 16
        }
    ],
    "Career": [
        {
            "interestAreaName": "Technology",
            "isSelected": false,
            "interestAreaId": 1
        },
        {
            "interestAreaName": "AI/ML",
            "isSelected": false,
            "interestAreaId": 2
        },
        {
            "interestAreaName": "Cloud",
            "isSelected": true,
            "interestAreaId": 3
        },
        {
            "interestAreaName": "AR/VR",
            "isSelected": false,
            "interestAreaId": 4
        },
        {
            "interestAreaName": "Cloud Computing",
            "isSelected": false,
            "interestAreaId": 5
        },
        {
            "interestAreaName": "DevOps",
            "isSelected": false,
            "interestAreaId": 6
        },
        {
            "interestAreaName": "Mobile Apps",
            "isSelected": false,
            "interestAreaId": 7
        },
        {
            "interestAreaName": "UI/UX",
            "isSelected": false,
            "interestAreaId": 8
        },
        {
            "interestAreaName": "Data Science",
            "isSelected": false,
            "interestAreaId": 9
        },
        {
            "interestAreaName": "Microservices & Platform",
            "isSelected": false,
            "interestAreaId": 10
        }
    ]
},
"myMentors": [],
"userDetails": {
    "profileUrl": "https://ghantee.com/wp-content/uploads/2022/10/mobile-jesus-wallpaper.jpg",
    "isNotificationActive": false,
    "profileImgUrl": "https://ghantee.com/wp-content/uploads/2022/10/mobile-jesus-wallpaper.jpg",
    "contactNumber": "9689560753",
    "name": "Rachit Kumar",
    "employeeId": 2523,
    "designation": "Software Engineer",
    "band": "Band 1",
    "department": "Engineering",
    "experience": "3Y",
    "userId": 6,
    "email": "Rachit.Kumar@gmail.com"
}
}

现在，我想查询所有用户的数据，其中对于Map中的每个条目，即interestAreas，interestAreaName为“Cloud”且isSelected = true;
我一直在尝试查询：

@Query("{'interestAreas': {$exists: true, $ne: []},'interestAreas': { $elemMatch: {'v': '$in': {'interestAreaName': ?0, isSelected: true}}}}")
List<User> findAllByUserInterestAreasName(String tags);

mongodb

来源：https://stackoverflow.com/questions/74970401/query-for-nested-map-of-list-of-objects-in-spring-data-mongodb

1条答案

按热度按时间

yeotifhr1#

您可能必须使用聚合。

db.collection.aggregate([
  {
    "$addFields": {
      "interestArray": {
        $objectToArray: "$interestAreas"    //convert to an array of k,v pair, by adding new field
      }
    }
  },
  {
    $match: {
      "interestArray.v": {        //query the v field
        $elemMatch: {
          "interestAreaName": "Cloud",
          "isSelected": true
        }
      }
    }
  },
  {
    $project: {
      "interestArray": 0        //remove the added field from output
    }
  }
]);

Playground
您可以使用聚合框架支持或聚合存储库方法编写此代码

@Aggregation("<the entire pipeline>")
List<User> findAllByUserInterestAreasName(String tags);

赞(0）回复(0）举报 2023-01-04

我来回答

查询Spring数据mongodb中对象列表的嵌套Map

1条答案

相关问题

热门标签

最新问答