Spring data mongo db query on inner fields of embedded document (DBRef)

Question

I have a a document which is having references of two other document. I have to query in the basis of id of UserLogin and shopmaster. How I can achieve this. Please suggest how to query.

@Id
private String userShopAssociationId;

@DBRef
private UserLogin userLogin;

@DBRef
private ShopMaster shopMaster;

Query query = new Query();
query.addCriteria(Criteria.where("userLogin.$id").is(userShopAssociationForm.getUserLoginId()));
query.addCriteria(Criteria.where("shopMaster.$id").is(userShopAssociationForm.getShopMasterId());

Greg Potter · Accepted Answer · 2015-01-02 18:51:57Z

5

The queries that you have look correct; you should be able to query based on the _id of a DBRef. That's because a DBRef stores the collection, id, and (sometimes) the database on the parent document. However, you might need to convert the ids you are comparing to an ObjectId like so:

Query query = new Query();
query.addCriteria(Criteria.where("userLogin.$id").is(new ObjectId(userShopAssociationForm.getUserLoginId())));
query.addCriteria(Criteria.where("shopMaster.$id").is(new ObjectId(userShopAssociationForm.getShopMasterId()));

answered Jan 2, 2015 at 18:51

Greg Potter

5271 gold badge5 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

vinicius gati Over a year ago

and if not a dbref?

Collectives™ on Stack Overflow

Spring data mongo db query on inner fields of embedded document (DBRef)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related