On this page本页内容
$toString
New in version 4.0.在版本4.0中新增。
Converts a value to a string. If the value cannot be converted to a string, 将值转换为字符串。如果值无法转换为字符串,则$toString errors. $toString会出错。If the value is null or missing, 如果值为$toString returns null.null或缺失,$toString将返回null。
$toString has the following syntax:语法如下:
{
$toString: <expression>
}
The $toString takes any valid expression.$toString接受任何有效表达式。
The $toString is a shorthand for the following $convert expression:$toString是以下$convert表达式的缩写:
{ $convert: { input: <expression>, to: "string" } }
The following table lists the input types that can be converted to a string:下表列出了可以转换为字符串的输入类型:
| Boolean | |
| Double | |
| Decimal | |
| Integer | |
| Long | |
| ObjectId | |
| String | |
| Date |
The following table lists some conversion to string examples:下表列出了一些转换为字符串的示例:
{$toString: true} | "true" |
{$toString: false} | "false" |
{$toString: 2.5} | "2.5" |
{$toString: NumberInt(2)} | "2" |
{$toString: NumberLong(1000)} | "1000" |
{$toString: ObjectId("5ab9c3da31c2ab715d421285")} | "5ab9c3da31c2ab715d421285" |
{$toString: ISODate("2018-03-27T16:58:51.538Z")} | "2018-03-27T16:58:51.538Z" |
Create a collection 使用以下文档创建集合orders with the following documents:orders:
db.orders.insertMany( [
{ _id: 1, item: "apple", qty: 5, zipcode: 93445 },
{ _id: 2, item: "almonds", qty: 2, zipcode: "12345-0030" },
{ _id: 3, item: "peaches", qty: 5, zipcode: 12345 },
] )
The following aggregation operation on the orders collection converts the zipcode to string before sorting by the string value:orders集合上的以下聚合操作在按字符串值排序之前将zipcode转换为字符串:
// Define stage to add convertedZipCode field with the converted zipcode value zipConversionStage = { $addFields: { convertedZipCode: { $toString: "$zipcode" } } }; // Define stage to sort documents by the converted zipcode sortStage = { $sort: { "convertedZipCode": 1 } }; db.orders.aggregate( [ zipConversionStage, sortStage ] )
The operation returns the following documents:该操作返回以下文档:
{
_id: 3,
item: 'peaches',
qty: 5,
zipcode: 12345,
convertedZipCode: '12345'
},
{
_id: 2,
item: 'almonds',
qty: 2,
zipcode: '12345-0030',
convertedZipCode: '12345-0030'
},
{
_id: 1,
item: 'apple',
qty: 5,
zipcode: 93445,
convertedZipCode: '93445'
}