{"id":388,"date":"2018-04-11T12:07:10","date_gmt":"2018-04-11T10:07:10","guid":{"rendered":"https:\/\/kszyh.kisim.eu.org\/?p=388"},"modified":"2018-04-11T12:07:10","modified_gmt":"2018-04-11T10:07:10","slug":"mongodb-lookup-example","status":"publish","type":"post","link":"https:\/\/kszyh.kisim.eu.org\/?p=388","title":{"rendered":"MongoDB &#8211; lookup example"},"content":{"rendered":"<pre class=\"wrap:true lang:js decode:true \">db.getCollection('log').aggregate([\r\n{\r\n $lookup: {\r\n     from: 'users',\r\n     localField: 'meta.user',\r\n     foreignField: '_id',\r\n     as: 'user'\r\n     }   \r\n},\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{\r\n  $sort: {\r\n      timestamp: -1\r\n  }\r\n}\r\n])<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>db.getCollection(&#8217;log&#8217;).aggregate([ { $lookup: { from: 'users&#8217;, localField: 'meta.user&#8217;, foreignField: '_id&#8217;, as: 'user&#8217; } }, { $lookup: { from: 'patients&#8217;, localField: 'meta.patient&#8217;, foreignField: '_id&#8217;, as: 'patient&#8217; } }, { $sort: { timestamp: -1 } } ]) &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[92,97],"tags":[],"class_list":["post-388","post","type-post","status-publish","format-standard","hentry","category-java-script","category-mongodb"],"_links":{"self":[{"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=388"}],"version-history":[{"count":1,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions"}],"predecessor-version":[{"id":389,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions\/389"}],"wp:attachment":[{"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kszyh.kisim.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}