collection:
{
"username" : "gorim99949@x1post.com",
"channels" : [
{
"channelName" : "yyyyy",
"id" : 383,
"url" : "https://xxxxxxxxx",
}
],
}
@Document(collection = "user_masters")
public class UserMasters {
@Field("username")
private String userName;
@DBRef
private List<UserChannels> UserChannels userChannels;
******getter and setter*********
@Document(collection="channels")
public class UserChannels {
private String url;
************getter/setter****************
Repository class
public UserMasters findByUserName(String username);
@Test method
Query: userRepository.findByUserName(userName).getUserChannels().getUrl();如何从mongodb集合中的数组中获取url的值。我无法读取集合中数组中的值。提前感谢您的帮助
发布于 2020-11-16 17:30:57
为此,您将需要一个自定义查询。运行查询: db.collection.aggregate({$match:{username:"gorim99949@x1post.com"}},{$project:{"userChannels":"$channels.url"}});返回:[{"_id":ObjectId("5a934e000102030405000000"),"userChannels":“username您可以通过在投影中将_id设置为0来从返回文档中删除它。
https://stackoverflow.com/questions/64746194
复制相似问题