Counts log entries,\u00a0 with type equal 'CREATE’ , fetch patients data\u00a0 from another collection,\u00a0 remove empty documents (if patients was not found the field is empty array), count by provided user id.<\/p>\n
var user_id = '5ad070640c9faddd41a4b665'\r\n\r\ndb.getCollection('log').aggregate([\r\n{ $match: { message: {$eq: 'CREATE' } }},\r\n{\r\n $lookup: {\r\n from: 'patients',\r\n localField: 'meta.patient',\r\n foreignField: '_id',\r\n as: 'patient'\r\n } \r\n},\r\n{ $match: { patient: {$not: {$size: 0}} }},\r\n{ $match: {'meta.user': {$eq: ObjectId(user_id)}}},\r\n {\r\n $count: \"created\"\r\n }\r\n])<\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
Counts log entries,\u00a0 with type equal 'CREATE’ , fetch patients data\u00a0 from another collection,\u00a0 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’,… Continue reading