Mongodb compass query driver#
Mongodb compass query code#

Mongodb compass query code#

Here we discuss the Introduction, Mongo DB-like query by using find () function examples with code implementation respectively. The output is a cursor referencing the filtered document records. We can specify the string, regex, or regular expression for matching the values in the parameters of the find() function. We can implement the functionality of the like query in Mongo DB by using the find() function in the format – db.collection.find(). We can also change the name of the field specified in the above example as a city to whichever field as per requirement. The output of the execution of the above query statement will be as shown below retrieving the count as 1 because there is only one hill station located in Pune city as per the inserted sample database.Īs shown in the above query statement we can make the changes in the string mentioned between the two forward slashes to specify a different string to be matched each time. Let us firstly create a sample database shown below:

Mongodb compass query driver#

Note: If you want to have an access to the result set returned by the find() function with a driver then, in that case, you will have to use for that particular driver language, a cursor handling mechanism to handle the result set. The query parameter is used for filtering the selection of the records to be scanned by the find() function. The default value of the projection parameter when not specified retrieves all the fields of the document. Projection is used for specifying the fields to be retrieved for matching records.

The other way is through a query bar with auto-completion. It recently added an embedded MongoDB shell, which is a fully functional JavaScript environment for interacting with MongoDB deployments. Compass offers two ways to build queries.

Optional parameters – There are also other two optional parameters that can be passed to the find() function which are query and the projection. Querying in Compass requires some knowledge of the mongo shell syntax.

Open the MongoDB Compass and connect to the server. Example: You have to follow the below steps to understand the example using MongoDB compass. So, let’s get understand this followed by an example.

This find() function automatically iterates the result set for the first 20 records for displaying them in its result set. In this topic, you will understand how MongoDB compass works and how it will count the number of documents. We can further loop through this cursor to extract the result set and perform any further manipulation on the retrieved records if needed. Return value – The find() function returns a cursor containing all the matched document records in it.Parameter – Also inside the brackets, we can optionally specify the key-value pairs specifying which key should contain what value or should satisfy what condition while finding the records from the document. In the above syntax as the find() is the method of the collection class of db, we have to give it a call using this format and the dot notation only.