QueryBuilder queryBuidlerType = QueryBuilder.start("working").is(1); DBObject or1 = QueryBuilder.start().or(QueryBuilder.start("user").exists(true).get(), QueryBuilder.start("parent").exists(true).get()).get(); DBObject or2 = QueryBuilder.start().or(QueryBuilder.start("car.id").is(mId).and("car.model").is("mModel").get(), QueryBuilder.start("car.matched.id").is(mId).and("car.matched.model").is("mModel").get()).get(); queryBuidlerType.and(or1, or2); DBObject queryType = queryBuidlerType.get();
QueryBuilder qb = new QueryBuilder(); for (int x=0; x<2;x++) { qb.or(new BasicDBObject("this","that")); } QueryBuilder qb2 = new QueryBuilder(); qb2.and(qb.get()); QueryBuilder qb3 = new QueryBuilder(); for (int x=0; x<2;x++) { qb3.or(new BasicDBObject("something", "else")); } qb2.and(qb3.get()); System.out.println(qb2.get());
QueryBuilder builder = QueryBuilder.start(); builder.and("objectKey").regex(Pattern.compile("box")); builder.and("cache_version_string").is("08/03/15_11:05:09"); BasicDBObject query = (BasicDBObject)builder.get(); Bson projection = Projections.exclude( "_id", "obectdata", "lasModified", "productCode" ); MongoCursor<Document> cursor = collection.find(query).projection(projection).iterator(); while (cursor.hasNext()) { Document doc = cursor.next(); System.out.println(doc.toJson()); }
BasicDBObject document = new BasicDBObject(); Pattern regex = Pattern.compile("^((?!Salt).)*$"); QueryBuilder queryBuilder = new QueryBuilder(); queryBuilder.and( new QueryBuilder().put("contract").notEquals("none").get(), new QueryBuilder().put("contract").notEquals(null).get(), new QueryBuilder().put("contract").regex(regex).get() ); document.putAll(queryBuilder.get()); DBCursor cursor = getDbCollection().find(document);