published.js

published.js

db.getCollection('stix').aggregate([
        { $match: { 'stix.type': 'x-unfetter-assessment-set' } },
        {
            $project: {
                'stix.assessment_sets': {
                    $arrayElemAt: ['$stix.assessment_sets', 0]
                },
                'metaProperties.published': 1,
                'stix.id': 1,
                'stix.name': 1,
                'stix.modified': 1,
                'stix.created_by_ref': 1,
                creator: 1
            }
        },
        {
            $group: {
                _id: '$stix.id',
                id: {
                    $push: '$stix.id'
                },
                published: {
                    $first: '$metaProperties.published'
                },
                name: {
                    $first: '$stix.name'
                },
                modified: {
                    $max: '$stix.modified'
                },
                creator: {
                    $first: '$creator'
                },
                created_by_ref: {
                    $first: '$stix.created_by_ref'
                },
                stix: {
                    $addToSet: {
                        type: '$stix.assessment_sets.stix.type',
                        id: '$stix.id'
                    }
                }
            }
        },
        {
            $unwind: '$stix'
        },
        {
            $sort: {
                modified: -1
            }
        }
    ])