[DOCS-1521] Sort collections by a sub-element array feature using index gives a correct order Created: 16/May/13 Updated: 30/Oct/23 Resolved: 29/Jul/13 |
|
| Status: | Closed |
| Project: | Documentation |
| Component/s: | manual |
| Affects Version/s: | mongodb-2.4 |
| Fix Version/s: | Server_Docs_20231030 |
| Type: | Tracking | Priority: | Minor - P4 |
| Reporter: | braloum | Assignee: | Kay Kim (Inactive) |
| Resolution: | Done | Votes: | 0 |
| Labels: | array, bug, feature, query, sort | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Participants: | |||||||||
| Days since reply: | 10 years, 39 weeks, 6 days ago | ||||||||
| Description |
|
I have this kind of collection :
"Folders" can contains a lot of more elements, and reflects in which Folder "F_id" the file is available, and at what order it take place "Ord" in this folder. If I do something like :
I get the incorrect Order ! I thought I should use map/reduce or aggregation framework to perform this... But when I create an index:
With the same query :
I get the correct Order I expected ! Is it a bug, a stroke of luck or a feature I can count on in the future ?? If it is a feature, this should be written on the doc ! (as there is no more needs to use map/reduce nor aggregation framework) Regards |