[SERVER-3192] allow nesting $or within $and Created: 03/Jun/11 Updated: 14/Nov/17 Resolved: 24/Jun/11 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance, Querying |
| Affects Version/s: | None |
| Fix Version/s: | 1.9.1 |
| Type: | New Feature | Priority: | Major - P3 |
| Reporter: | Aaron Staple | Assignee: | Aaron Staple |
| Resolution: | Done | Votes: | 10 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||
| Comments |
| Comment by Aaron Staple [ 24/Jun/11 ] |
|
We've added in matching for nested or clauses, but not index support. Index support is |
| Comment by Thomas DeMille [ 23/Jun/11 ] |
|
I'm very hopeful this would include ability for multiple $OR? We are running into major issue implementing MongoDB for searches without multiple $or, for instance.. query = { $or: [ { IsBankOwned: true }, { IsShortSale: true }, { IsHUD: true }], $or: [ { AreaID: "2467" },{ CityID: { $in: [ "4651" ] }} ] } does not currently work so we can not use this for our search for real estate MLS where the search might be (as above) in this area OR that city AND IsBankOwned OR isShortSale the work around is to pull back a huge dataset and use code to parse out one of the OR elements. Thnks! |
| Comment by auto [ 16/Jun/11 ] |
|
Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}Message: |
| Comment by auto [ 16/Jun/11 ] |
|
Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}Message: |
| Comment by auto [ 16/Jun/11 ] |
|
Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}Message: |
| Comment by auto [ 16/Jun/11 ] |
|
Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}Message: |
| Comment by auto [ 16/Jun/11 ] |
|
Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}Message: |
| Comment by Aaron Staple [ 07/Jun/11 ] |
|
We are planning to implement a useful portion of this functionality for 1.9.1 |
| Comment by Luke Maurer [ 03/Jun/11 ] |
|
I just want to emphasize: So for us, and I'd have to guess for 99% of people who cared about |