Aggregation – Czit notes

User LAST LOGIN stats

przez kszyh | 10 maja 2019 - 08:10 |10 maja 2019 Bez kategorii, MongoDB

Get datetime of last successful login of each user – from logs collection

// Requires official MongoShell 3.6+
db.getCollection("log").aggregate(
    [
        {
            $match: {
                "message": { "$eq": "USER_SUCCESS_LOGIN" }
            }
        },
        {
            $sort: { timestamp: -1 }
        },
        {
            $lookup: {
                "from": "users",
                "localField": "meta.user",
                "foreignField": "_id",
                "as": "user"
            }
        },
        {
            $match: {
                "user": { $ne: [] }
            }
        },
        {
            $unwind: { path: "$user" }
        },
        {
            $project: {
                "timestamp": { $dateToString: { format: "%Y-%m-%d %H:%M:%S:%L", date: "$timestamp" }} ,
                "message": 1,
                "userid": "$user._id",
                "firstName": "$user.firstName",
                "lastName": "$user.lastName",
            }
        },
        {
            $group:
                {
                    "_id": "$userid",
                    "firstName": { $first: "$firstName" },
                    "lastName": { $first: "$lastName" },
                    "lastLogin": { $first: "$timestamp" }
                }
        }

    ],
    {
        "allowDiskUse": true
    }
);

// Requires official MongoShell 3.6+

db.getCollection("log").aggregate(

[

{

$match: {

"message": { "$eq": "USER_SUCCESS_LOGIN" }

}

{

$sort: { timestamp: -1 }

{

$lookup: {

"from": "users",

"localField": "meta.user",

"foreignField": "_id",

"as": "user"

}

{

$match: {

"user": { $ne: [] }

}

{

$unwind: { path: "$user" }

{

$project: {

"timestamp": { $dateToString: { format: "%Y-%m-%d %H:%M:%S:%L", date: "$timestamp" }} ,

"message": 1,

"userid": "$user._id",

"firstName": "$user.firstName",

"lastName": "$user.lastName",

}

{

$group:

{

"_id": "$userid",

"firstName": { $first: "$firstName" },

"lastName": { $first: "$lastName" },

"lastLogin": { $first: "$timestamp" }

}

{

"allowDiskUse": true

}

);

Count documents using Aggregation

przez kszyh | 21 sierpnia 2018 - 07:46 |21 sierpnia 2018 MongoDB, Skrypty

Dodaj komentarz

Counts log entries, with type equal 'CREATE’ , fetch patients data from another collection, remove empty documents (if patients was not found the field is empty array), count by provided user id.

var user_id = '5ad070640c9faddd41a4b665'

db.getCollection('log').aggregate([
{ $match: { message: {$eq: 'CREATE' } }},
{
 $lookup: {
     from: 'patients',
     localField: 'meta.patient',
     foreignField: '_id',
     as: 'patient'
     }   
},
{ $match: { patient: {$not: {$size: 0}} }},
{ $match: {'meta.user': {$eq: ObjectId(user_id)}}},
    {
      $count: "created"
    }
])

var user_id = '5ad070640c9faddd41a4b665'

db.getCollection('log').aggregate([

{ $match: { message: {$eq: 'CREATE' } }},

{

$lookup: {

from: 'patients',

localField: 'meta.patient',

foreignField: '_id',

as: 'patient'

}

{ $match: { patient: {$not: {$size: 0}} }},

{ $match: {'meta.user': {$eq: ObjectId(user_id)}}},

{

$count: "created"

}

])

Archiwa tagu: Aggregation

User LAST LOGIN stats

Count documents using Aggregation

Ostatnie wpisy

Najnowsze komentarze

Kategorie

Meta