%% Retrieve Specific Number of Documents Using Offset
% Connect to MongoDB® using the MongoDB C++ interface and retrieve a specific number of documents in a collection in the database. Return documents from a specific position in the results using an offset value. Import the documents into MATLAB®. In this example, each document in the collection represents an employee.
%
% Create a MongoDB connection to the database mongotest using the MongoDB C++ interface. Here, the database server dbtb01 hosts this database using port number 27017.

server = "dbtb01";
port = 27017;
dbname = "mongotest";
conn = mongoc(server,port,dbname)

% conn is the connection object that contains the MongoDB connection. The object properties contain information about the connection and the database.
% The database name is mongotest.
% The user name is blank.
% The database server is dbtb01.
% The port number is 27017.
% This database contains 13 document collections.
%
% Verify the MongoDB connection.

isopen(conn)

% The database connection is successful because the isopen function returns 1. Otherwise, the database connection is closed.
%
% Specify the employees collection for document retrieval.

collection = "employees";

%
% Use the name-value argument Skip to skip the first five documents in the collection. Then, use the name-value argument Limit to return the next 10 documents in the collection. documents is a cell array that contains 10 documents.

documents = find(conn,collection,Skip=5,Limit=10);

%
% Close the MongoDB connection.

close(conn)

% Copyright 2020 The MathWorks, Inc.