[COUCHDB-2867] Mango: should be able to index *within* arrays

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Component/s: Mango
• Assignee: Unassigned
• Reporter: Nolan Lawson
• Created: 03/Nov/15 12:53
• Updated: 02/Sep/18 07:07
• Resolved: 02/Sep/18 07:07

Description

If you have a document like:

{
  "_id": "foo",
  "tags": ["a", "b", "c"]
}

...then you should be able to run queries that find e.g. all documents with "a" as a tag, and it should be indexed. Currently there doesn't seem to be any way to do this except as an in-memory selector, which is a real bummer, because it's a super common use case. (Tags, categories, labels, etc.)

Originally I thought this was how $elemMatch worked, and I was surprised to learn that that's not the case.

Issue Links

• is duplicated by: COUCHDB-2927 Move $elemMatch into view query instead of in-memory