How to find datatype of all the fields in MongoDB?

Use typeof to find datatype of all the fields −

typeof db.yourCollectionName.findOne().yourFieldName;

Let us first create a collection with documents −

> db.findDataTypeDemo.insertOne({"ClientName":"Chris","isMarried":false});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ccf2064dceb9a92e6aa1952")
}

Following is the query to display all documents from a collection with the help of find() method −

> db.findDataTypeDemo.findOne();

This will produce the following output −

{
   "_id" : ObjectId("5ccf2064dceb9a92e6aa1952"),
   "ClientName" : "Chris",
   "isMarried" : false
}

Following is the query to find datatype of a field in MongoDB −

> typeof db.findDataTypeDemo.findOne().isMarried;

This will produce the following output −

Boolean

Here is the query to get the data type of another field −

> typeof db.findDataTypeDemo.findOne().ClientName;

This will produce the following output −

String

You can get the value also. The query is as follows −

> db.findDataTypeDemo.findOne().ClientName;
Chris
> db.findDataTypeDemo.findOne().isMarried;
False

Nishtha Thakur

Published on 22-May-2019 07:41:54

• Related Questions & Answers
• How to retrieve all nested fields from MongoDB collection?
• The collection.find() always returns all fields with MongoDB?
• Find sum of fields inside array in MongoDB?
• Include all existing fields and add new fields to document in MongoDB?
• MongoDB query to display all the fields value, except _id
• Get all fields names in a MongoDB collection?
• Group all documents with common fields in MongoDB?
• Select special fields rather than all in MongoDB
• How to re-map the fields of a MongoDB collection?
• How do I work with array fields in MongoDB to match all?
• MongoDB collection query to exclude some fields in find()?
• What is the fastest way to update the whole document (all fields) in MongoDB?
• Sort array in MongoDB query and project all fields?
• MongoDB query to check the existence of multiple fields
• How to remove key fields in MongoDB?