find_documents_based_on_region.js

new Region()
        .publishedDocuments()
        .query(function(q){
            q.join('regions', 'regions.id', '=', 'documentRegions.region_id');
            q.whereIn('regions.id', regionIds);
            q.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
            });
        });