MongoDB and Java driver: "ignore case" in request

Question

This is the code I'm using now, how do I add an attribute "ignore case"?

DBObject query = new BasicDBObject("prop", value); 

thanks

Answer 1

When I had the exact problem, I could not request, ignoring the case. I ended up copying the value I wanted to find in order to normalize it. In this case, you can create a new property and convert it to lowercase and have an index.

EDIT:

 DBObject ref = new BasicDBObject(); ref.put("myfield", Pattern.compile(".*myValue.*" , Pattern.CASE_INSENSITIVE)); DBCursor cur = coll.find(ref); 

I wonder if this works?

Answer 2

In case you use Spring -java below, this is the way you can perform case insensitive searches.

 public List<Discussion> searchQuestionByText(String qText){ Query query = new Query(); query.addCriteria(Criteria.where("discussionName").regex(qText,"i")); return mongoTemplate.find(query, Discussion.class); } 

Answer 3

 db.iolog.find({$where:"this.firstname.toLowerCase()==\"telMan\".toLowerCase()"}); DBObject ref = new BasicDBObject(); ref.append("firstname", new BasicDBObject("$where","this.firstname.toLowerCase()=="+firstname+".toLowerCase()")); 

Answer 4

I also tried to make the best use of the case-insensitive implementation. If you are using MongoDB Java driver 3.0 or later, you should use this following code with the $ parameter option! It is really easy to use:

 Document basicQuery = new Document(); basicQuery.append("key", new Document("$regex","value").append("$options","i")); 

The fields "key" and "value" must be changed using your own data.

(I also advise you to search using the $ regex parameter to obtain information by partially matching if there are more and more records in the database.)

Answer 5

  mapValue = new HashMap<String, Object>(); mapValue.put("$options", "i"); mapValue.put("$regex", "smth"); searchMap.put("name", mapValue); collection.find(new BasicDBObject(searchMap));