find_documents_based_on_region.js

new Region()
        .publishedDocuments()
        .query({whereIn: ['regions.id', regionIds], where: ['publishedDocuments.updated_at', '>=', new Date(timestamp)]})
        .fetchAll({withRelated: [
            'publishedDocuments.images',
            'publishedDocuments.ecareSections',
            'publishedDocuments.regions']
        })
        .then(function (collection) {
            var map = {}, keys, i, maxLength, result = [];

            collection.forEach(function (region) {
                region.relations.publishedDocuments.forEach(function (document) {
                    if (map[document.id] === undefined) {
                        map[document.id] = document;
                        result.push(document);
                    }
                });
            });

            res.json({
                total_documents: result.length,
                documents: result
            });
        });