How to convert value to string using $toString in MongoDB?

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

痴情的苹果 · BufferedReader如何一次读取所有 ...· 8 小时前 ·

气势凌人的跑步机 · BufferedReader的读取行数问题_ ...· 8 小时前 ·

读研的面包 · Java ...· 8 小时前 ·

失落的炒饭 · java中如何获取文件的行数 | ...· 8 小时前 ·

率性的羽毛球 · Java 读取文件的 5 种方式 - ...· 8 小时前 ·

胆小的马克杯 · Quick start - ...· 2 周前 ·

豪气的小摩托 · 保姆级qBittorrent ...· 1 月前 ·

光明磊落的高山 · 2017亚洲旅游产业年会收官，“一带一路”倡 ...· 4 月前 ·

彷徨的绿茶 · QSslSocket Class | Qt ...· 7 月前 ·

大方的红豆 · NuGet Gallery ...· 9 月前 ·

Let us see an example to understand the $toString in MongoDB. To understand the above concept, let us create a collection with the document. The query to create a collection with a document is as follows −

> db.objectidToStringDemo.insertOne({"UserName":"John"});
   "acknowledged" : true,
   "insertedId" : ObjectId("5c92b80036de59bd9de0639d")
> db.objectidToStringDemo.insertOne({"UserName":"Chris"});
   "acknowledged" : true,
   "insertedId" : ObjectId("5c92b80436de59bd9de0639e")
> db.objectidToStringDemo.insertOne({"UserName":"Larry"});
   "acknowledged" : true,
   "insertedId" : ObjectId("5c92b80936de59bd9de0639f")
> db.objectidToStringDemo.insertOne({"UserName":"Robert"});
   "acknowledged" : true,
   "insertedId" : ObjectId("5c92b81836de59bd9de063a0")
}

Display all documents from a collection with the help of find() method. The query is as follows −

> db.objectidToStringDemo.find().pretty();

The following is the output −

{ "_id" : ObjectId("5c92b80036de59bd9de0639d"), "UserName" : "John" }
{ "_id" : ObjectId("5c92b80436de59bd9de0639e"), "UserName" : "Chris" }
{ "_id" : ObjectId("5c92b80936de59bd9de0639f"), "UserName" : "Larry" }
{ "_id" : ObjectId("5c92b81836de59bd9de063a0"), "UserName" : "Robert" }

Here is the query to convert ObjectId to a string value in MongoDB aggregate. The query is as follows −

> db.objectidToStringDemo.aggregate([
   ... {
      ... $project: {
         ... _id: {
            ... $toString: "$_id"
         ... }
      ... }
   ... }
... ]
... );

The following is the output −

{ "_id" : "5c92b80036de59bd9de0639d" }
{ "_id" : "5c92b80436de59bd9de0639e" }
{ "_id" : "5c92b80936de59bd9de0639f" }
{ "_id" : "5c92b81836de59bd9de063a0" }

In order to get the original ObjectId, use the $toObjectId operator −

> db.objectidToStringDemo.aggregate([ { $project: { _id: { $toObjectId: "$_id" } } } ] );

The following is the output −

{ "_id" : ObjectId("5c92b80036de59bd9de0639d") }
{ "_id" : ObjectId("5c92b80436de59bd9de0639e") }
{ "_id" : ObjectId("5c92b80936de59bd9de0639f") }
{ "_id" : ObjectId("5c92b81836de59bd9de063a0") }

How to convert ObjectId to string in MongoDB

Java Program to convert Double into String using toString() method of Double class

How to convert string to numerical values in MongoDB?

Convert Long into String using toString() method of Long class in java

Convert NumberLong to String in MongoDB?

Convert string to objectid in MongoDB?

How to get the string representation of numbers using toString() in Java?

How to convert a boolean value to string value in JavaScript?

How to convert from string to date data type in MongoDB?

MongoDB query to convert string to int?

Java Program to convert string value to float using Float.valueOf()

Convert Hexadecimal value String to ASCII value String in C++