$slice mongoDB Java [英] $slice mongoDB Java

问题描述

如何在 Java 中进行此查询

How can I make this query in Java

db.comments.find({ "hsID.$id" { "$oid" : "4fe71a50e7e9f22ae5fb96bf"}} , {commentList: { $slice : [ 2 , 2]}});

这是我正在做的代码

    BasicDBObject query = new BasicDBObject();
        BasicDBObject allFields = new BasicDBObject();
        ObjectId objectId = new ObjectId(objId);
        query.put("{hsID.$id", objectId);
        Integer[] sliceInt = { startIndex, pageSize };
        query.put( 
                "commentList",
                new BasicDBObject().append("$slice", sliceInt));
 DBCursor resultsCursor = CommentColl.find(allFields,query);

输出为

输出是

query  = { "{hsID.$id" : { "$oid" : "4fe71a50e7e9f22ae5fb96bf"} , "commentList" : { "$slice" : [ 2 , 2]}}

感谢您的帮助

推荐答案

您需要将查询与要返回的字段分开.尝试更像这样的事情:

You need to separate the query from the fields you want returned. Try something more like this:

BasicDBObject query = new BasicDBObject("hsID.$id", new ObjectId(objId));
BasicDBObject fields = new BasicDBObject(
      "commentList",
       new BasicDBObject("$slice", new int[] { startIndex, pageSize }));
DBCursor resultsCursor = CommentColl.find(query, fields);

另请注意，我删除了您在 hsid.$id 之前的左花括号.

Notice also that I removed the opening curly brace that you had preceding hsid.$id.

这篇关于$slice mongoDB Java的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！