Morphia query with or operator

java mongodb morphia
user1573690 picture user1573690 · Jul 26, 2013 · Viewed 10.3k times · Source

I want to know how to write a Morphia mongodb query with 'or' operator
I wrote mongodb query like this and this work fine 

db.Inv.find({$or:[{sug_id:2},{grp_id:2}]})

But i got confused when i try to write this in morphia, following query is wrong but how can write something similar to this 

List<Inv> invs = ds.find(Inv.class).field("grp_id").hasAnyOf(grpId).or(field("sug_id")).hasAnyOf(grpId).asList();

Thanks

Answer

evanchooly picture evanchooly · Jul 26, 2013

not sure why hasAnyOf() is in there but try this:

Query<Inv> query = ds.find(Inv.class);            
query.or(
  query.criteria("grp_id").equal(2),
  query.criteria("sug_id").equal(2));
List<Inv> invs = query.asList();

Related questions

Unit testing with MongoDB

My database of choice is MongoDB. I'm writing a data-layer API to abstract implementation details from client applications - that is, I'm essentially providing a single public interface (an object which acts as an IDL). I'm testing my logic as …

Read More
MongoDB Composite Key

I'm just getting started with MongoDb and I've noticed that I get a lot of duplicate records for entries that I meant to be unique. I would like to know how to use a composite key for my data and …

Read More
Can't find a codec for my class

I have simple class named Signal. Class looks as follows: public class Signal { private String id; private Date timestamp; public String getId() { return id; } public void setId(String id) { this.id = id; } public Date getTimestamp() { return timestamp; } public void setTimestamp(…

Read More