search by param values of referenced objects in mongodb

Question

Is it possible to search based on some param value of a DBRef object in spring data.

eg. say we have two objects, Car, and Company as shown

Class Car {

   @Id
   String id;
   String model;
   @DBRef
   Company company;
}

Class Company {

   @Id
   String id;
   String name;
}

Can I write a query to fetch all car's of Hyundai company like this,

Query queryForCars = new Query(Criteria.where("company.name").is("Hyundai")), Car.class)

It works fine for non referenced objects, but for referenced object it's working in my case.

Thanks for your help.

MongoDB docs suggest that use manual references intead of DBRef. — vmr, Aug 28 '14 at 14:00
Yes, but I need it in some use cases to be able to eager fetch the referenced objects. — shailesh, Aug 28 '14 at 14:02

score 1 · Answer 1 · answered Aug 28 '14 at 14:20

1

For referenced objects this is how your query should look like:

Query queryForCars = new Query(Criteria.where("company.$name").is("Hyundai")), Car.class)

answered Aug 28 '14 at 14:20

vmr

I remember this to work long back, but now doesn't seem to work. Any idea? – shailesh Oct 07 '14 at 13:19
Not getting the result at all! as if the criteria is not matching. – shailesh Oct 07 '14 at 13:33

1 Answers1