> I am using this query in Mongo shell and getting desired result.

> db.MyCollection.find( {"owner":"abc" , $where: "if ( ( this.myArray &&
> this.myArray.length > 1 ) ) { return this; } " } ).count();

> Return all documents where the array "myArray" is not null and its size is
> greater than 1.

> I am finding it hard to implement this in Java.

> BasicDBObject query = new BasicDBObject("owner", "abc");
> query.put( "myArray", new BasicDBObject("$ne", null) );
> query.put("myArray", new BasicDBObject("$size", 2) );

> How could I query for all documents having the size of the array "to"
> greater than 1?

> Thanks,
> Shekhar

> You can achieve the effect you want using the $exists operator and the "."
> operator:

> The shell code is like:
>     db.MyCollection.find( {"owner":"abc" , "myArray.1" : { "$exists" : true

> } } )

> Basically saying "match an array with a second element".  Indexes are zero
> based.

> The Java side looks like:
>    BasicDBObject query = new BasicDBObject("owner", "abc");
>    query.put("myArray.1", new BasicDBObject("$exists", Boolean.TRUE) );

> If you use the Asynchronous driver<http://www.allanbank.com/mongodb-async-driver/>that turns into:

>     DocumentAssignable query = QueryBuilder<http://www.allanbank.com/mongodb-async-driver/apidocs/index.html?com/...>
> .where("owner").equals("abc")

> .and("myArray.1").exists();

> Rob

> On Tuesday, September 11, 2012 5:06:20 PM UTC-4, shekhar agrawal wrote:

> > I am using this query in Mongo shell and getting desired result.

> > db.MyCollection.find( {"owner":"abc" , $where: "if ( ( this.myArray &&
> > this.myArray.length > 1 ) ) { return this; } " } ).count();

> > Return all documents where the array "myArray" is not null and its size is
> > greater than 1.

> > I am finding it hard to implement this in Java.

> > BasicDBObject query = new BasicDBObject("owner", "abc");
> > query.put( "myArray", new BasicDBObject("$ne", null) );
> > query.put("myArray", new BasicDBObject("$size", 2) );

> > How could I query for all documents having the size of the array "to"
> > greater than 1?

> > Thanks,
> > Shekhar