// SAMPLE STORED PROCEDURE
function sample(projectId, linkageCode) {
    var collection = getContext().getCollection();
    var output = {
        interviewDate: '',
        birthDate: ''
    };

        // this is not returning anything at the moment stuck here
        var result = collection.chain()
            .filter(function (doc) {
                return doc.projectId == projectId
            })
            .filter(function (doc) {
                return doc.CaseNumber == caseNumber
            })
            .unwind(doc => doc.ItemDetails, (doc, details) => { return { doc, dayName: details.Name, dayValue: details.ItemValue }; })
            .unwind(doc => doc.doc.ItemDetails, (doc, details) => { return { doc, monthName: details.Name, monthValue: details.ItemValue }; })
            .unwind(doc => doc.doc.ItemDetails, (doc, details) => { return { yearName: details.Name, yearValue: details.ItemValue }; })
            .filter(doc => ( doc.dayName == dateFields['day'] ))
            .filter(doc => ( doc.monthName == dateFields['month'] ))
            .filter(doc => ( doc.yearName == dateFields['year'] ))
            .map(doc => ( {day: doc.dayValue, month: doc.monthValue, year: doc.yearValue} ))
            .value({}, function (error, resources, options) {
                console.log(JSON.stringify(resources));
            });

        return result;
    }

    // this part works as expected return the casenumber
    var linkageCodeResult = collection.chain()
        .filter(function (doc) {
            return doc.projectId == projectId
        })
        .unwind(s => s.ItemDetails, (s, i) => { return { caseNumber: s.CaseNumber, itemName: i.Name, itemValue: i.ItemValue } })
        .filter(function (si) {
            return si.itemName == 'LINKAGE_CODE';
        })
        .filter(function (postCouns) {
            return postCouns.itemValue == linkageCode
        })
        .pluck('caseNumber')
        .value({}, function (error, resources, options) {
            var caseNumber = resources[0];
            console.log(caseNumber);

            //this part is not returning the dates
            var interviewDateResult = dateResult(
                caseNumber,
                { 'day': 'IINTD', 'month': 'IINTM', 'year': 'IINTY' },
                'interviewDate'
            );
            var birthDateResult = dateResult(
                caseNumber,
                { 'day': 'I0102A', 'month': 'I0102M', 'year': 'I0102Y' },
                'birthDate'
            );
        });
}