![]() ![]() On the drop-down menu for the second stage, select the $lookup operator, as shown in the image above. This way, we don’t have to care about removing movies without comments, but all comments from the time window. Based on the collection on the “left” (comments), select the documents on the “right” (movies) that match a given field in both, in this case, the movie id. The $lookup operator does a “left outer join”. Click the “Add stage” button below the first stage to start working on adding the movie information to the collection using the $lookup operator. ![]() Including the movie information in the filtered comments you just got from the first stage is the second step of our aggregation. You’ll notice that the comments don’t have the movie information, but the movie identification number (ID) is present, as shown in the image below. ![]() This operator result will be all the documents between August 1st and August 31st 2002.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |