Tags » Aggregation

Aggregation using CAML query

Recently i was working on a CSOM code where i needed to do some total of values present in list column and count of items from list in SharePoint list. 421 more words

SharePoint

MongoDB aggregations

So doing some simple aggregations in MongoDB took me a few minutes to figure out. Clearly, I am not well versed in JSON (and a legacy aversion to curly bracelets stemming from 3 semesters of C# doesn’t help…). 133 more words

Mongo

Heavy Police Presence on Street Following Las Vegas Shooting. Credit - Twitter/Max Michor via Storyful

{“contentType”:”VIDEO”,”id”:{“value”:”e95a6aac32a83a637419bcd8b4db1568″,”link”:”http:\/\/api.newsapi.com.au\/content\/v2\/e95a6aac32a83a637419bcd8b4db1568″},”originId”:”5348771529001-5595404735001″,”origin”:”BRIGHTCOVE”,”title”:”Heavy Police Presence on Street Following Las Vegas Shooting. Credit – Twitter\/Max Michor via Storyful”,”subtitle”:”Heavy Police Presence on Street Following Las Vegas Shooting. Credit – Twitter\/Max Michor via Storyful”,”description”:”More than 20 people were killed and more than 100 wounded when a gunman opened fire at a country music festival at the Mandalay Bay Resort in Las Vegas on Sunday, October 1, police said. 1,746 more words

National

To read is to understand and engage. 265 more words

Journalism

Kid can’t stop yelling ‘boobies’ on TV

{“contentType”:”NEWS_STORY”,”id”:{“value”:”00703dba23b1ce89eaa7baf5fda0ab86″,”link”:”http:\/\/api.newsapi.com.au\/content\/v2\/00703dba23b1ce89eaa7baf5fda0ab86″},”originId”:”6b6cc9e4-a18a-11e7-a137-e90e4491bb29″,”origin”:”METHODE”,”channel”:”NONE”,”title”:”Kid can\u2019t stop yelling \u2018boobies\u2019 on TV”,”subtitle”:”Today Extra: Melinda Schneider\u2019s son steals the show by repeatedly yelling \u2018boobies\u2019″,”description”:”

ONE of Australia\u2019s most successful country music singers was upstaged on TV this morning by her five-year-old son.“,”link”:”http:\/\/cdn.newsapi.com.au\/link\/00703dba23b1ce89eaa7baf5fda0ab86″,”paidStatus”:”NON_PREMIUM”,”originalSource”:”news.com.au”,”creditedSource”:”news.com.au”,”originalAssetId”:”6b6cc9e4-a18a-11e7-a137-e90e4491bb29″,”version”:”PUBLISHED”,”dateUpdated”:”2017-09-25T08:55:38.000Z”,”dateLive”:”2017-09-25T00:42:00.000Z”,”customDate”:”2017-09-25T08:55:00.000Z”,”dateCreated”:”2017-09-25T00:42:33.000Z”,”status”:”ACTIVE”,”thumbnailImage”:{“contentType”:”IMAGE”,”id”:{“value”:”082db3cbe9e94bb9c544cad2b7f1df6c”,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/082db3cbe9e94bb9c544cad2b7f1df6c”},”originId”:”crop-8b5ddbe7d725cf7248b8746cf5f59179″,”origin”:”METHODE”,”title”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”subtitle”:”70f29544-a192-11e7-a137-e90e4491bb29″,”description”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/thumbnail\/082db3cbe9e94bb9c544cad2b7f1df6c”,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Channel 9″,”version”:”PUBLISHED”,”dateUpdated”:”2017-09-25T03:10:53.000Z”,”dateLive”:”2017-09-25T00:42:00.000Z”,”dateCreated”:”2017-09-25T01:39:59.000Z”,”status”:”ACTIVE”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[“tv”,”nine”],”authors”:[],”domains”:[“newscorpaustralia.com”,”cairnspost.com.au”,”ntnews.com.au”,”couriermail.com.au”,”goldcoastbulletin.com.au”,”themercury.com.au”,”heraldsun.com.au”,”adelaidenow.com.au”,”news.com.au”,”townsvillebulletin.com.au”,”perthnow.com.au”,”dailytelegraph.com.au”,”geelongadvertiser.com.au”],”locationGeoPoints”:[],”userOriginUpdated”:”weirj”,”systemOriginUpdated”:”METHODE”,”domainOriginUpdated”:”None”,”urlTitle”:”70f29544a19211e7a137e90e4491bb29″,”revision”:2,”format”:”jpeg”,”width”:100,”height”:75,”imageName”:”today3.jpg”,”imageType”:”THUMBNAIL”,”sourceImageId”:”70f29544-a192-11e7-a137-e90e4491bb29″,”cropName”:”4:3-Thumbnail”},”related”:[{“contentType”:”IMAGE”,”id”:{“value”:”f8acfbb42661d4c0b1a0221460946488″,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/f8acfbb42661d4c0b1a0221460946488″},”originId”:”crop-b22eccf637c445adcb8c10071f36a40c”,”origin”:”METHODE”,”title”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”subtitle”:”700bcf56-a192-11e7-a137-e90e4491bb29″,”description”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/f8acfbb42661d4c0b1a0221460946488″,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Channel 9″,”version”:”PUBLISHED”,”dateUpdated”:”2017-09-25T03:10:53.000Z”,”dateLive”:”2017-09-25T00:42:00.000Z”,”dateCreated”:”2017-09-25T01:39:57.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[“tv”,”nine”],”authors”:[],”domains”:[“newscorpaustralia.com”,”cairnspost.com.au”,”ntnews.com.au”,”couriermail.com.au”,”goldcoastbulletin.com.au”,”themercury.com.au”,”heraldsun.com.au”,”adelaidenow.com.au”,”news.com.au”,”townsvillebulletin.com.au”,”perthnow.com.au”,”dailytelegraph.com.au”,”geelongadvertiser.com.au”],”locationGeoPoints”:[],”userOriginUpdated”:”weirj”,”systemOriginUpdated”:”METHODE”,”domainOriginUpdated”:”None”,”urlTitle”:”700bcf56a19211e7a137e90e4491bb29″,”revision”:2,”containerTypes”:[“SUBSTITUTE”],”format”:”jpeg”,”width”:650,”height”:366,”imageName”:”today1.jpg”,”imageType”:”SUBSTITUTE”,”sourceImageId”:”700bcf56-a192-11e7-a137-e90e4491bb29″,”cropName”:”MajorEventNoCaption650x366″},{“contentType”:”IMAGE”,”id”:{“value”:”9016bb2c7a2b1ef0b5f4e36f75bb58ea”,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/9016bb2c7a2b1ef0b5f4e36f75bb58ea”},”originId”:”crop-8808d4bae70da7b28239ad7c999f3c10″,”origin”:”METHODE”,”title”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”subtitle”:”700bcf56-a192-11e7-a137-e90e4491bb29″,”description”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/9016bb2c7a2b1ef0b5f4e36f75bb58ea”,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Channel 9″,”version”:”PUBLISHED”,”dateUpdated”:”2017-09-25T03:10:53.000Z”,”dateLive”:”2017-09-25T00:42:00.000Z”,”dateCreated”:”2017-09-25T01:39:57.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[“tv”,”nine”],”authors”:[],”domains”:[“newscorpaustralia.com”,”cairnspost.com.au”,”ntnews.com.au”,”couriermail.com.au”,”goldcoastbulletin.com.au”,”themercury.com.au”,”heraldsun.com.au”,”adelaidenow.com.au”,”news.com.au”,”townsvillebulletin.com.au”,”perthnow.com.au”,”dailytelegraph.com.au”,”geelongadvertiser.com.au”],”locationGeoPoints”:[],”userOriginUpdated”:”weirj”,”systemOriginUpdated”:”METHODE”,”domainOriginUpdated”:”None”,”urlTitle”:”700bcf56a19211e7a137e90e4491bb29″,”revision”:2,”containerTypes”:[“SUBSTITUTE”],”format”:”jpeg”,”width”:316,”height”:421,”imageName”:”today1.jpg”,”imageType”:”SUBSTITUTE”,”sourceImageId”:”700bcf56-a192-11e7-a137-e90e4491bb29″,”cropName”:”StoryPortrait316x421″},{“contentType”:”IMAGE”,”id”:{“value”:”152b78b345c931a2a2c9e65175ddcf3d”,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/152b78b345c931a2a2c9e65175ddcf3d”},”originId”:”crop-3b3325d47d1ae14076c03f80de2feee7″,”origin”:”METHODE”,”title”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”subtitle”:”7097227c-a192-11e7-a137-e90e4491bb29″,”description”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/152b78b345c931a2a2c9e65175ddcf3d”,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Channel 9″,”version”:”PUBLISHED”,”dateUpdated”:”2017-09-25T03:10:53.000Z”,”dateLive”:”2017-09-25T00:42:00.000Z”,”dateCreated”:”2017-09-25T01:39:58.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[“tv”,”nine”],”authors”:[],”domains”:[“newscorpaustralia.com”,”cairnspost.com.au”,”ntnews.com.au”,”couriermail.com.au”,”goldcoastbulletin.com.au”,”themercury.com.au”,”heraldsun.com.au”,”adelaidenow.com.au”,”news.com.au”,”townsvillebulletin.com.au”,”perthnow.com.au”,”dailytelegraph.com.au”,”geelongadvertiser.com.au”],”locationGeoPoints”:[],”userOriginUpdated”:”weirj”,”systemOriginUpdated”:”METHODE”,”domainOriginUpdated”:”None”,”urlTitle”:”7097227ca19211e7a137e90e4491bb29″,”revision”:2,”containerTypes”:[“SUBSTITUTE”],”format”:”jpeg”,”width”:316,”height”:237,”imageName”:”today4.jpg”,”imageType”:”SUBSTITUTE”,”sourceImageId”:”7097227c-a192-11e7-a137-e90e4491bb29″,”cropName”:”StoryNoCaption316x237″},{“contentType”:”IMAGE”,”id”:{“value”:”1677a1f35b241629fa79e40905bebd8b”,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/1677a1f35b241629fa79e40905bebd8b”},”originId”:”crop-f1e028488f2a46ae8a681c9fba37757e”,”origin”:”METHODE”,”title”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”subtitle”:”7097227c-a192-11e7-a137-e90e4491bb29″,”description”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/1677a1f35b241629fa79e40905bebd8b”,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Channel 9″,”version”:”PUBLISHED”,”dateUpdated”:”2017-09-25T03:10:53.000Z”,”dateLive”:”2017-09-25T00:42:00.000Z”,”dateCreated”:”2017-09-25T01:39:58.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[“tv”,”nine”],”authors”:[],”domains”:[“newscorpaustralia.com”,”cairnspost.com.au”,”ntnews.com.au”,”couriermail.com.au”,”goldcoastbulletin.com.au”,”themercury.com.au”,”heraldsun.com.au”,”adelaidenow.com.au”,”news.com.au”,”townsvillebulletin.com.au”,”perthnow.com.au”,”dailytelegraph.com.au”,”geelongadvertiser.com.au”],”locationGeoPoints”:[],”userOriginUpdated”:”weirj”,”systemOriginUpdated”:”METHODE”,”domainOriginUpdated”:”None”,”urlTitle”:”7097227ca19211e7a137e90e4491bb29″,”revision”:2,”containerTypes”:[“SUBSTITUTE”],”format”:”jpeg”,”width”:196,”height”:110,”imageName”:”today4.jpg”,”imageType”:”SUBSTITUTE”,”sourceImageId”:”7097227c-a192-11e7-a137-e90e4491bb29″,”cropName”:”TabletThumbnail196x110″},{“contentType”:”IMAGE”,”id”:{“value”:”4ce3b283e3a1493a72f92bee84d5b3e2″,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/4ce3b283e3a1493a72f92bee84d5b3e2″},”originId”:”crop-3c18223cb3297f7c580004eea6b86a9e”,”origin”:”METHODE”,”title”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”subtitle”:”7097227c-a192-11e7-a137-e90e4491bb29″,”description”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/4ce3b283e3a1493a72f92bee84d5b3e2″,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Channel 9″,”version”:”PUBLISHED”,”dateUpdated”:”2017-09-25T03:10:53.000Z”,”dateLive”:”2017-09-25T00:42:00.000Z”,”dateCreated”:”2017-09-25T01:39:58.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[“tv”,”nine”],”authors”:[],”domains”:[“newscorpaustralia.com”,”cairnspost.com.au”,”ntnews.com.au”,”couriermail.com.au”,”goldcoastbulletin.com.au”,”themercury.com.au”,”heraldsun.com.au”,”adelaidenow.com.au”,”news.com.au”,”townsvillebulletin.com.au”,”perthnow.com.au”,”dailytelegraph.com.au”,”geelongadvertiser.com.au”],”locationGeoPoints”:[],”userOriginUpdated”:”weirj”,”systemOriginUpdated”:”METHODE”,”domainOriginUpdated”:”None”,”urlTitle”:”7097227ca19211e7a137e90e4491bb29″,”revision”:2,”containerTypes”:[“SUBSTITUTE”],”format”:”jpeg”,”width”:149,”height”:86,”imageName”:”today4.jpg”,”imageType”:”SUBSTITUTE”,”sourceImageId”:”7097227c-a192-11e7-a137-e90e4491bb29″,”cropName”:”PromoThumbnail149x86″},{“contentType”:”IMAGE”,”id”:{“value”:”c46cce0855002574ceb0b09e3e5bb155″,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/c46cce0855002574ceb0b09e3e5bb155″},”originId”:”crop-f66dfcde1754e05c52649e3d24dee050″,”origin”:”METHODE”,”title”:”Sullivan was hilarious on Today Extra this morning.”,”subtitle”:”700bcf56-a192-11e7-a137-e90e4491bb29″,”description”:”Sullivan was hilarious on Today Extra this morning.”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/c46cce0855002574ceb0b09e3e5bb155″,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Channel 9″,”version”:”PUBLISHED”,”dateUpdated”:”2017-09-25T03:10:53.000Z”,”dateLive”:”2017-09-25T00:42:00.000Z”,”dateCreated”:”2017-09-25T01:39:57.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[“tv”,”nine”],”authors”:[],”domains”:[“newscorpaustralia.com”,”cairnspost.com.au”,”ntnews.com.au”,”couriermail.com.au”,”goldcoastbulletin.com.au”,”themercury.com.au”,”heraldsun.com.au”,”adelaidenow.com.au”,”news.com.au”,”townsvillebulletin.com.au”,”perthnow.com.au”,”dailytelegraph.com.au”,”geelongadvertiser.com.au”],”locationGeoPoints”:[],”userOriginUpdated”:”weirj”,”systemOriginUpdated”:”METHODE”,”domainOriginUpdated”:”None”,”urlTitle”:”700bcf56a19211e7a137e90e4491bb29″,”revision”:2,”containerTypes”:[“EMBEDDED”],”format”:”jpeg”,”width”:650,”height”:366,”imageName”:”today1.jpg”,”imageType”:”EMBEDDED”,”sourceImageId”:”700bcf56-a192-11e7-a137-e90e4491bb29″,”cropName”:”MajorEvent650x366″},{“contentType”:”IMAGE”,”id”:{“value”:”f1695a6da8dcdd4dce9ab988c38bc1f6″,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/f1695a6da8dcdd4dce9ab988c38bc1f6″},”originId”:”crop-67db5d6ec74cc2bd24effb651c745f71″,”origin”:”METHODE”,”title”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”subtitle”:”7097227c-a192-11e7-a137-e90e4491bb29″,”description”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’.”,”link”:”http:\/\/cdn.newsapi.com.au\/image\/v1\/f1695a6da8dcdd4dce9ab988c38bc1f6″,”paidStatus”:”NON_PREMIUM”,”originalSource”:”Channel 9″,”version”:”PUBLISHED”,”dateUpdated”:”2017-09-25T03:10:53.000Z”,”dateLive”:”2017-09-25T00:42:00.000Z”,”dateCreated”:”2017-09-25T01:39:58.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”related”:[],”domainLinks”:[],”categories”:[],”keywords”:[“tv”,”nine”],”authors”:[],”domains”:[“newscorpaustralia.com”,”cairnspost.com.au”,”ntnews.com.au”,”couriermail.com.au”,”goldcoastbulletin.com.au”,”themercury.com.au”,”heraldsun.com.au”,”adelaidenow.com.au”,”news.com.au”,”townsvillebulletin.com.au”,”perthnow.com.au”,”dailytelegraph.com.au”,”geelongadvertiser.com.au”],”locationGeoPoints”:[],”userOriginUpdated”:”weirj”,”systemOriginUpdated”:”METHODE”,”domainOriginUpdated”:”None”,”urlTitle”:”7097227ca19211e7a137e90e4491bb29″,”revision”:2,”containerTypes”:[“PRIMARY”],”format”:”jpeg”,”width”:650,”height”:366,”imageName”:”today4.jpg”,”imageType”:”PRIMARY”,”sourceImageId”:”7097227c-a192-11e7-a137-e90e4491bb29″,”cropName”:”MajorEvent650x366″},{“contentType”:”VIDEO”,”id”:{“value”:”e8f95cc11cc3b3cb8f7dfd60b58b07cb”,”link”:”http:\/\/api.newsapi.com.au\/content\/v2\/e8f95cc11cc3b3cb8f7dfd60b58b07cb”},”originId”:”5348771529001-5587522470001″,”origin”:”BRIGHTCOVE”,”title”:”Country music star’s kid can’t stop saying ‘boobies’ on live TV”,”subtitle”:”Country music star’s kid can’t stop saying ‘boobies’ on live TV”,”description”:”Country music star’s kid can’t stop saying ‘boobies’ on live TV”,”link”:”http:\/\/cdn.newsapi.com.au\/link\/e8f95cc11cc3b3cb8f7dfd60b58b07cb?domain=theaustralian.com.au”,”paidStatus”:”NON_PREMIUM”,”originalSource”:”NND”,”version”:”PUBLISHED”,”dateUpdated”:”2017-09-25T00:25:22.000Z”,”dateLive”:”2017-09-25T00:21:59.000Z”,”dateCreated”:”2017-09-25T00:21:51.000Z”,”status”:”ACTIVE”,”referenceType”:”PRIMARY”,”thumbnailImage”:{“contentType”:”IMAGE”,”id”:{“value”:”f2542c7f53c67066fa7503068b822fee”,”link”:”http:\/\/api.newsapi.com.au\/image\/v1\/f2542c7f53c67066fa7503068b822fee”},”originId”:”5348771529001-5587522470001-thumbnail”,”origin”:”BRIGHTCOVE”,”title”:”Country music star’s kid can’t stop saying ‘boobies’ on live TV”,”description”:”Country music star Melinda Schneider’s son made his first appearance on live TV and just couldn’t stop saying his favourite word, ‘boobies’. 3,282 more words

Australia

Breaking Down Apple's Special Event (9/12/17) - Part 3 & 4

I will be releasing my “Breakdown of Apple’s Special Event (9/12/17)” as a series of articles. Part 5 will cover iPhone. Enjoy!

3. WATCH

WATCH Series 3 has cellular! 285 more words

Business