Versions Compared

Old Version 13

changes.mady.by.user Aaron Roworth

Saved on

compared with

New Version Current

changes.mady.by.user Aaron Roworth

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info
titleMongo Documentation

We use find and aggregrate mongo query types. You can read up on how the mongo aggregation pipeline works here.

Taking our event from earlier, let's write some queries to display some of the data we were seeing.



Code Block
languagejs
titleEvents
collapsetrue
{
  "utilities": [
    {
      "_id": "594376d9f59a7c6d1cb00e18",
      "name": "Server CLI Request",
      "tags": {
        "value": 1497509263823,
        "label": "aaron",
        "action": "Start",
        "category": "Videos"
      },
      "date": "2017-06-16T06:12:41.402Z",
      "__v": 0
    },
    {
      "_id": "594376d9f59a7c6d1cb00e19",
      "name": "Server CLI Request",
      "tags": {
        "value": 1497509350209,
        "label": "kynan",
        "action": "Stop",
        "category": "Videos"
      },
      "date": "2017-06-16T06:12:41.402Z",
      "__v": 0
    },
    {
      "_id": "59437648f59a7c6d1cb00e12",
      "name": "Server CLI Request",
      "tags": {
        "value": 1497509263823,
        "label": "aaron",
        "action": "Start",
        "category": "Videos"
      },
      "date": "2017-06-16T06:10:15.991Z",
      "__v": 0
    },
    {
      "_id": "59437648f59a7c6d1cb00e13",
      "name": "Server CLI Request",
      "tags": {
        "value": 1497509350209,
        "label": "kynan",
        "action": "Stop",
        "category": "Videos"
      },
      "date": "2017-06-16T06:10:15.991Z",
      "__v": 0
    },
    {
      "_id": "59437348f59a7c6d1cb00e01",
      "name": "Server CLI Request",
      "tags": {
        "value": 1497592616045,
        "label": "HowTo",
        "action": "Start",
        "category": "Videos"
      },
      "date": "2017-06-16T05:57:28.370Z",
      "__v": 0
    },
    {
      "_id": "594372b4f59a7c6d1cb00dfd",
      "name": "Server CLI Request",
      "tags": {
        "value": 1497592500120,
        "label": "HowTo",
        "action": "Start",
        "category": "Videos"
      },
      "date": "2017-06-16T05:55:00.120Z",
      "__v": 0
    }
  ]
}



Requests By

Date and Name

Tag Name in Last X Weeks


Code Block
languagejs
themeFadeToGrey
titleQuery
[  
   {  
      "$match":{  
         "tags.category":"#category#",
         "tags.action": "#action#",
    "date":{  
            "$gte":"#gte#",
            "$lte":"#lte#"
         }
      }
   },
   {  
      "$project":{  
         "action":"$tags.action"
      }
   },
   {  
      "$group":{  
         "_id":"$action",
         "count":{  
            "$sum":1
         }
      }
   }
]



Query Parameters

Click the image to increase the size.


Code Block
languagejs
themeEmacs
titleResult
{
  "utilities": [
    {
      "_id": "Start",
      "count": 4
    }
  ]
}



Actions in Specific Category


Code Block
languagejs
themeFadeToGrey
titleQuery
[
  {
    "$match": {
      "tags.request.answerSpace.name": "#answerspace#",
      "tags.request.answerSpace.form": {
        "$exists": true
      },
      "date": {
        "$gte": "#gte#",
        "$lte": "#lte#"
      }
    }
  },
  {
    "$project": {
      "form": "$tags.request.answerSpace.form"
    }
  },
  {
    "$group": {
      "_id": "$form",
      "count": {
        "$sum": 1
      }
    }
  }
]



Image AddedClick the image to increase the size.


Code Block
languagejs
themeEmacs
titleResult
{
  "utilities": [
    {
      "_id": "Stop",
      "count": 2
    },
    {
      "_id": "Start",
      "count": 4
    }
  ]
}


Next Step

Setting up your Dashboard