Hi guys, how can I get all the meta ID that has the key-value "aacain": "Anthony Acain"

Couchbase Server
1

Here is the sample doc.

{
  "bluetooth": false,
  "doctype": "mobileconfig",
  "sections": [
    {
      "fields": [
        {
          "alias": "Assigned To",
          "dropDownOptions": {
            "aacain": "Anthony Acain",
          },
        }
      ],
      "sectiontitle": "Service Order Information"
    },

  ],
}
2

yes, you can use meta().id to get meta.id() and use where clause for field ''aacain"

3

N1QL.

CREATE INDEX ix1 ON default ( DISTINCT ARRAY (DISTINCT ARRAY f.dropDownOptions.aacain FOR f IN s.fields END) FOR s IN sections END ) WHERE doctype = "mobileconfig";
SELECT META(d).id
FROM default AS d
WHERE d.doctype = "mobileconfig"
AND ANY s IN d.sections SATISFIES (ANY f IN s.fields SATISFIES f.dropDownOptions.aacain = "Anothony  Acain" END) END;