检索部分数组属性

根据您的情况,我建议您使用 Stored Procedure

样本代码:

function sample() {
    var collection = getContext().getCollection();

    var isAccepted = collection.queryDocuments(
        collection.getSelfLink(),
        'SELECT p.FullName, p.Children FROM People AS p',
    function (err, feed, options) {
        if (err) throw err;
        if (!feed || !feed.length) {
            var response = getContext().getResponse();
            response.setBody('no docs found');
        }
        else {
            var response = getContext().getResponse();
            var returnResult = [];
            for(var i = 0;i<feed.length;i++){
                var peopleObj = feed[i];
                ChildrenArray = [];               
                for(var j = 0;j<peopleObj.Children.length;j++){
                    console.log(j)
                    var childObj = peopleObj.Children[j];
                    HobbiesArray = [];
                    for(var k = 0; k < childObj.Hobbies.length;k++){
                        var hobbyObj = childObj.Hobbies[k];
                        map ={};
                        map["Title"] = hobbyObj.Title;
                        HobbiesArray.push(map);
                    }
                    childObj.Hobbies = HobbiesArray;
                }
                ChildrenArray.push(childObj);
            }
            returnResult.push(peopleObj);
            getContext().getResponse().setBody(returnResult);
        }
    });

    if (!isAccepted) throw new Error('The query was not accepted by the server.');
}

[
    {
        "FullName": "Jim",
        "Children": [
            {
                "Name": "Sue",
                "Hobbies": [
                    {
                        "Title": "Stamps"
                    },
                    {
                        "Title": "Baseball"
                    }
                ]
            },
            {
                "Name": "Frank",
                "Hobbies": [
                    {
                        "Title": "Dance"
                    },
                    {
                        "Title": "Juggling"
                    }
                ]
            }
        ]
    }
]