{"id":184853,"date":"2023-08-21T00:29:27","date_gmt":"2023-08-20T16:29:27","guid":{"rendered":"http:\/\/www.idc.net\/help\/184853\/"},"modified":"2023-08-21T00:29:27","modified_gmt":"2023-08-20T16:29:27","slug":"%e5%90%8e%e6%b5%aa%e4%ba%91%e5%b0%8f%e7%a8%8b%e5%ba%8f%e6%95%99%e7%a8%8b%ef%bc%9asdk%e6%95%b0%e6%8d%ae%e5%ba%93-command%c2%b7%e8%81%9a%e5%90%88%e6%93%8d%e4%bd%9c%e7%ac%a6%c2%b7%e7%ae%97%e6%95%b0","status":"publish","type":"post","link":"https:\/\/idc.net\/help\/184853\/","title":{"rendered":"\u540e\u6d6a\u4e91\u5c0f\u7a0b\u5e8f\u6559\u7a0b\uff1aSDK\u6570\u636e\u5e93 Command\u00b7\u805a\u5408\u64cd\u4f5c\u7b26\u00b7\u7b97\u6570\u64cd\u4f5c\u7b26"},"content":{"rendered":"

AggregateCommand.abs(value: Expression<number>): Object<\/h2>\n

\n \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n

\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u8fd4\u56de\u4e00\u4e2a\u6570\u5b57\u7684\u7edd\u5bf9\u503c\u3002<\/p>\n

\u53c2\u6570<\/h2>\n

value: Expression<number><\/h3>\n

number<\/p>\n

\u8fd4\u56de\u503c<\/h2>\n

Object<\/h3>\n

API \u8bf4\u660e<\/h2>\n

\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n

db.command.aggregate.abs(<number>)\n<\/code><\/pre>\n
abs \u4f20\u5165\u7684\u503c\u9664\u4e86\u6570\u5b57\u5e38\u91cf\u5916\uff0c\u4e5f\u53ef\u4ee5\u662f\u4efb\u4f55\u6700\u7ec8\u89e3\u6790\u6210\u4e00\u4e2a\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
\u5982\u679c\u8868\u8fbe\u5f0f\u89e3\u6790\u4e3a null \u6216\u8005\u6307\u5411\u4e00\u4e2a\u4e0d\u5b58\u5728\u7684\u5b57\u6bb5\uff0c\u5219 abs \u7684\u7ed3\u679c\u662f null\u3002\u5982\u679c\u503c\u89e3\u6790\u4e3a NaN\uff0c\u5219\u7ed3\u679c\u662f NaN\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 ratings \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ _id: 1, start: 5, end: 8 }\n{ _id: 2, start: 4, end: 4 }\n{ _id: 3, start: 9, end: 7 }\n{ _id: 4, start: 6, end: 7 }\n<\/code><\/pre>\n
\u00b7\u00b7\u00b7 \u53ef\u4ee5\u7528\u5982\u4e0b\u65b9\u5f0f\u6c42\u5f97\u5404\u4e2a\u8bb0\u5f55\u7684 start \u548c end \u4e4b\u95f4\u7684\u7edd\u5bf9\u5dee\u5f02\u5927\u5c0f\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('ratings').aggregate()\n  .project({\n    delta: $.abs($.subtract(['$start', '$end']))\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ \"_id\" : 1, \"delta\" : 3 }\n{ \"_id\" : 2, \"delta\" : 0 }\n{ \"_id\" : 3, \"delta\" : 2 }\n{ \"_id\" : 4, \"delta\" : 1 }<\/code><\/pre>\n
\n
AggregateCommand.add(value: Expression[]): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u5c06\u6570\u5b57\u76f8\u52a0\u6216\u5c06\u6570\u5b57\u52a0\u5728\u65e5\u671f\u4e0a\u3002\u5982\u679c\u6570\u7ec4\u4e2d\u7684\u5176\u4e2d\u4e00\u4e2a\u503c\u662f\u65e5\u671f\uff0c\u90a3\u4e48\u5176\u4ed6\u503c\u5c06\u88ab\u89c6\u4e3a\u6beb\u79d2\u6570\u52a0\u5728\u8be5\u65e5\u671f\u4e0a\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression[]<\/h3>\n
[<\u8868\u8fbe\u5f0f1>, <\u8868\u8fbe\u5f0f2>, ...]<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.add([<\u8868\u8fbe\u5f0f1>, <\u8868\u8fbe\u5f0f2>, ...])\n<\/code><\/pre>\n
\u8868\u8fbe\u5f0f\u53ef\u4ee5\u662f\u5f62\u5982 $ + \u6307\u5b9a\u5b57\u6bb5\uff0c\u4e5f\u53ef\u4ee5\u662f\u666e\u901a\u5b57\u7b26\u4e32\u3002\u53ea\u8981\u80fd\u591f\u88ab\u89e3\u6790\u6210\u5b57\u7b26\u4e32\u5373\u53ef\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 staff \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ _id: 1, department: \"x\", sales: 5, engineer: 10, lastUpdate: ISODate(\"2019-05-01T00:00:00Z\") }\n{ _id: 2, department: \"y\", sales: 10, engineer: 20, lastUpdate: ISODate(\"2019-05-01T02:00:00Z\") }\n{ _id: 3, department: \"z\", sales: 20, engineer: 5, lastUpdate: ISODate(\"2019-05-02T03:00:00Z\") }\n<\/code><\/pre>\n
\u6570\u5b57\u6c42\u548c<\/h4>\n
\u53ef\u4ee5\u7528\u5982\u4e0b\u65b9\u5f0f\u6c42\u5f97\u5404\u4e2a\u8bb0\u5f55\u4eba\u6570\u603b\u6570\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('staff').aggregate()\n  .project({\n    department: 1,\n    total: $.add(['$sales', '$engineer'])\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ _id: 1, department: \"x\", total: 15 }\n{ _id: 2, department: \"y\", total: 30 }\n{ _id: 3, department: \"z\", total: 25 }\n<\/code><\/pre>\n
\u589e\u52a0\u65e5\u671f\u503c<\/h4>\n
\u5982\u4e0b\u64cd\u4f5c\u53ef\u4ee5\u83b7\u53d6\u5404\u4e2a\u8bb0\u5f55\u7684 lastUpdate \u52a0\u4e00\u4e2a\u5c0f\u65f6\u4e4b\u540e\u7684\u503c\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('staff').aggregate()\n  .project({\n    department: 1,\n    lastUpdate: $.add(['$lastUpdate', 60*60*1000])\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ _id: 1, department: \"x\", lastUpdate: ISODate(\"2019-05-01T01:00:00Z\") }\n{ _id: 2, department: \"y\", lastUpdate: ISODate(\"2019-05-01T03:00:00Z\") }\n{ _id: 3, department: \"z\", lastUpdate: ISODate(\"2019-05-02T04:00:00Z\") }<\/code><\/pre>\n
\n
AggregateCommand.ceil(value: Expression<number>): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u5411\u4e0a\u53d6\u6574\uff0c\u8fd4\u56de\u5927\u4e8e\u6216\u7b49\u4e8e\u7ed9\u5b9a\u6570\u5b57\u7684\u6700\u5c0f\u6574\u6570\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression<number><\/h3>\n
number<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.ceil(<number>)\n<\/code><\/pre>\n
<number> \u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u89e3\u6790\u4e3a null \u6216\u6307\u5411\u4e00\u4e2a\u4e0d\u5b58\u5728\u7684\u5b57\u6bb5\uff0c\u5219\u8fd4\u56de null\uff0c\u5982\u679c\u89e3\u6790\u4e3a NaN\uff0c\u5219\u8fd4\u56de NaN\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 sales \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ _id: 1, sales: 5.2 }\n{ _id: 2, sales: 1.32 }\n{ _id: 3, sales: -3.2 }\n<\/code><\/pre>\n
\u53ef\u4ee5\u7528\u5982\u4e0b\u65b9\u5f0f\u53d6\u5404\u4e2a\u6570\u5b57\u7684\u5411\u4e0a\u53d6\u6574\u503c\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('sales').aggregate()\n  .project({\n    sales: $.ceil('$sales')\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ _id: 1, sales: 6 }\n{ _id: 2, sales: 2 }\n{ _id: 3, sales: -3 }<\/code><\/pre>\n
\n
AggregateCommand.divide(value: Expression[]): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u4f20\u5165\u88ab\u9664\u6570\u548c\u9664\u6570\uff0c\u6c42\u5546\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression[]<\/h3>\n
[<\u88ab\u9664\u6570\u8868\u8fbe\u5f0f>, <\u9664\u6570\u8868\u8fbe\u5f0f>]<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.divide([<\u88ab\u9664\u6570\u8868\u8fbe\u5f0f>, <\u9664\u6570\u8868\u8fbe\u5f0f>])\n<\/code><\/pre>\n
\u8868\u8fbe\u5f0f\u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 railroads \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ _id: 1, meters: 5300 }\n{ _id: 2, meters: 64000 }\n{ _id: 3, meters: 130 }\n<\/code><\/pre>\n
\u53ef\u4ee5\u7528\u5982\u4e0b\u65b9\u5f0f\u53d6\u5404\u4e2a\u6570\u5b57\u8f6c\u6362\u4e3a\u5343\u7c73\u4e4b\u540e\u7684\u503c\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('railroads').aggregate()\n  .project({\n    km: $.divide(['$meters', 1000])\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ _id: 1, km: 5.3 }\n{ _id: 2, km: 64 }\n{ _id: 3, km: 0.13 }<\/code><\/pre>\n
\n
AggregateCommand.exp(value: Expression<number>): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u53d6 e\uff08\u81ea\u7136\u5bf9\u6570\u7684\u5e95\u6570\uff0c\u6b27\u62c9\u6570\uff09 \u7684 n \u6b21\u65b9\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression<number><\/h3>\n
exponent<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.exp(<exponent>)\n<\/code><\/pre>\n
<exponent> \u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u89e3\u6790\u4e3a null \u6216\u6307\u5411\u4e00\u4e2a\u4e0d\u5b58\u5728\u7684\u5b57\u6bb5\uff0c\u5219\u8fd4\u56de null\uff0c\u5982\u679c\u89e3\u6790\u4e3a NaN\uff0c\u5219\u8fd4\u56de NaN\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 math \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ _id: 1, exp: 0 }\n{ _id: 2, exp: 1 }\n{ _id: 3, exp: 2 }\n<\/code><\/pre>\n
const $ = db.command.aggregate\ndb.collection('math').aggregate()\n  .project({\n    result: $.exp('$exp')\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ _id: 1, result: 1 }\n{ _id: 2, result: 2.71828182845905 }\n{ _id: 3, result: 7.38905609893065 }<\/code><\/pre>\n
\n
AggregateCommand.floor(value: Expression<number>): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u5411\u4e0b\u53d6\u6574\uff0c\u8fd4\u56de\u5927\u4e8e\u6216\u7b49\u4e8e\u7ed9\u5b9a\u6570\u5b57\u7684\u6700\u5c0f\u6574\u6570\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression<number><\/h3>\n
number<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.floor(<number>)\n<\/code><\/pre>\n
<number> \u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u89e3\u6790\u4e3a null \u6216\u6307\u5411\u4e00\u4e2a\u4e0d\u5b58\u5728\u7684\u5b57\u6bb5\uff0c\u5219\u8fd4\u56de null\uff0c\u5982\u679c\u89e3\u6790\u4e3a NaN\uff0c\u5219\u8fd4\u56de NaN\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 sales \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ _id: 1, sales: 5.2 }\n{ _id: 2, sales: 1.32 }\n{ _id: 3, sales: -3.2 }\n<\/code><\/pre>\n
\u53ef\u4ee5\u7528\u5982\u4e0b\u65b9\u5f0f\u53d6\u5404\u4e2a\u6570\u5b57\u7684\u5411\u4e0b\u53d6\u6574\u503c\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('sales').aggregate()\n  .project({\n    sales: $.floor('$sales')\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ _id: 1, sales: 5 }\n{ _id: 2, sales: 1 }\n{ _id: 3, sales: -6 }<\/code><\/pre>\n
\n
AggregateCommand.ln(value: Expression<number>): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u8ba1\u7b97\u7ed9\u5b9a\u6570\u5b57\u5728\u81ea\u7136\u5bf9\u6570\u503c\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression<number><\/h3>\n
number<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.ln(<number>)\n<\/code><\/pre>\n
<number> \u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u975e\u8d1f\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
ln \u7b49\u4ef7\u4e8e log([<number>, Math.E])\uff0c\u5176\u4e2d Math.E \u662f JavaScript \u83b7\u53d6 e \u7684\u503c\u7684\u65b9\u6cd5\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
db.command.aggregate.ln<\/h2>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u8ba1\u7b97\u7ed9\u5b9a\u6570\u5b57\u5728\u81ea\u7136\u5bf9\u6570\u503c\u3002<\/p>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.ln(<number>)\n<\/code><\/pre>\n
<number> \u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u975e\u8d1f\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
ln \u7b49\u4ef7\u4e8e log([<number>, Math.E])\uff0c\u5176\u4e2d Math.E \u662f JavaScript \u83b7\u53d6 e \u7684\u503c\u7684\u65b9\u6cd5\u3002<\/p>\n
\n
AggregateCommand.log(value: Expression[]): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u8ba1\u7b97\u7ed9\u5b9a\u6570\u5b57\u5728\u7ed9\u5b9a\u5bf9\u6570\u5e95\u4e0b\u7684 log \u503c\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression[]<\/h3>\n
[<number>, <base>]<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.log([<number>, <base>])\n<\/code><\/pre>\n
<number> \u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u975e\u8d1f\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<base> \u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u5927\u4e8e 1 \u7684\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
\u5982\u679c\u4efb\u4e00\u53c2\u6570\u89e3\u6790\u4e3a null \u6216\u6307\u5411\u4efb\u610f\u4e00\u4e2a\u4e0d\u5b58\u5728\u7684\u5b57\u6bb5\uff0clog \u8fd4\u56de null\u3002\u5982\u679c\u4efb\u4e00\u53c2\u6570\u89e3\u6790\u4e3a NaN\uff0clog \u8fd4\u56de NaN\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 curve \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ _id: 1, x: 1 }\n{ _id: 2, x: 2 }\n{ _id: 3, x: 3 }\n<\/code><\/pre>\n
\u8ba1\u7b97 log2(x) \u7684\u503c\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('staff').aggregate()\n  .project({\n    log: $.log(['$x', 2])\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ _id: 1, log: 0 }\n{ _id: 2, log: 1 }\n{ _id: 3, log: 1.58496250072 }<\/code><\/pre>\n
\n
AggregateCommand.log10(value: Expression<number>): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u8ba1\u7b97\u7ed9\u5b9a\u6570\u5b57\u5728\u5bf9\u6570\u5e95\u4e3a 10 \u4e0b\u7684 log \u503c\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression<number><\/h3>\n
number<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.log(<number>)\n<\/code><\/pre>\n
<number> \u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u975e\u8d1f\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
log10 \u7b49\u540c\u4e8e log \u65b9\u6cd5\u7684\u7b2c\u4e8c\u4e2a\u53c2\u6570\u56fa\u5b9a\u4e3a 10\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
db.command.aggregate.log10<\/h2>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u8ba1\u7b97\u7ed9\u5b9a\u6570\u5b57\u5728\u5bf9\u6570\u5e95\u4e3a 10 \u4e0b\u7684 log \u503c\u3002<\/p>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.log(<number>)\n<\/code><\/pre>\n
<number> \u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u975e\u8d1f\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
log10 \u7b49\u540c\u4e8e log \u65b9\u6cd5\u7684\u7b2c\u4e8c\u4e2a\u53c2\u6570\u56fa\u5b9a\u4e3a 10\u3002<\/p>\n
\n
AggregateCommand.mod(value: Expression[]): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u53d6\u6a21\u8fd0\u7b97\uff0c\u53d6\u6570\u5b57\u53d6\u6a21\u540e\u7684\u503c\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression[]<\/h3>\n
[<dividend>, <divisor>]<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.mod([<dividend>, <divisor>])\n<\/code><\/pre>\n
\u7b2c\u4e00\u4e2a\u6570\u5b57\u662f\u88ab\u9664\u6570\uff0c\u7b2c\u4e8c\u4e2a\u6570\u5b57\u662f\u9664\u6570\u3002\u53c2\u6570\u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 shopping \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ _id: 1, bags: 3, items: 5 }\n{ _id: 2, bags: 2, items: 8 }\n{ _id: 3, bags: 5, items: 16 }\n<\/code><\/pre>\n
\u5404\u8bb0\u5f55\u53d6 items \u9664\u4ee5 bags \u7684\u4f59\u6570\uff08items % bags\uff09\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('shopping').aggregate()\n  .project({\n    overflow: $.mod(['$items', '$bags'])\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ _id: 1, log: 2 }\n{ _id: 2, log: 0 }\n{ _id: 3, log: 1 }<\/code><\/pre>\n
\n
AggregateCommand.multiply(value: Expression[]): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u53d6\u4f20\u5165\u7684\u6570\u5b57\u53c2\u6570\u76f8\u4e58\u7684\u7ed3\u679c\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression[]<\/h3>\n
[<expression1>, <expression2>, ...]<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.multiply([<expression1>, <expression2>, ...])\n<\/code><\/pre>\n
\u53c2\u6570\u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 fruits \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ \"_id\": 1, \"name\": \"apple\", \"price\": 10, \"quantity\": 100 }\n{ \"_id\": 2, \"name\": \"orange\", \"price\": 15, \"quantity\": 50 }\n{ \"_id\": 3, \"name\": \"lemon\", \"price\": 5, \"quantity\": 20 }\n<\/code><\/pre>\n
\u6c42\u5404\u4e2a\u6c34\u679c\u7684\u7684\u603b\u4ef7\u503c\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('fruits').aggregate()\n  .project({\n    name: 1,\n    total: $.multiply(['$price', '$quantity']),\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ \"_id\": 1, \"name\": \"apple\", \"total\": 1000 }\n{ \"_id\": 2, \"name\": \"orange\", \"total\": 750 }\n{ \"_id\": 3, \"name\": \"lemo\", \"total\": 100 }<\/code><\/pre>\n
\n
AggregateCommand.pow(value: Expression[]): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u6c42\u7ed9\u5b9a\u57fa\u6570\u7684\u6307\u6570\u6b21\u5e42\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression[]<\/h3>\n
[<base>, <exponent>]<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.pow([<base>, <exponent>])\n<\/code><\/pre>\n
\u53c2\u6570\u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 stats \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ \"_id\": 1, \"x\": 2, \"y\": 3 }\n{ \"_id\": 2, \"x\": 5, \"y\": 7 }\n{ \"_id\": 3, \"x\": 10, \"y\": 20 }\n<\/code><\/pre>\n
\u6c42 x \u548c y \u7684\u5e73\u65b9\u548c\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('stats').aggregate()\n  .project({\n    sumOfSquares: $.add([$.pow(['$x', 2]), $.pow(['$y', 2])]),\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ \"_id\": 1, \"sumOfSquares\": 13 }\n{ \"_id\": 2, \"sumOfSquares\": 74 }\n{ \"_id\": 3, \"sumOfSquares\": 500 }<\/code><\/pre>\n
\n
AggregateCommand.sqrt(value: Expression[]): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u6c42\u5e73\u65b9\u6839\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression[]<\/h3>\n
[<number>]<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.sqrt([<number>])\n<\/code><\/pre>\n
\u53c2\u6570\u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u975e\u8d1f\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u76f4\u89d2\u4e09\u89d2\u5f62\u96c6\u5408 triangle \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ \"_id\": 1, \"x\": 2, \"y\": 3 }\n{ \"_id\": 2, \"x\": 5, \"y\": 7 }\n{ \"_id\": 3, \"x\": 10, \"y\": 20 }\n<\/code><\/pre>\n
\u5047\u8bbe x \u548c y \u5206\u522b\u4e3a\u4e24\u76f4\u89d2\u8fb9\uff0c\u5219\u6c42\u659c\u8fb9\u957f\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('triangle').aggregate()\n  .project({\n    len: $.sqrt([$.add([$.pow(['$x', 2]), $.pow(['$y', 2])])]),\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ \"_id\": 1, \"len\": 3.605551275463989 }\n{ \"_id\": 2, \"len\": 8.602325267042627 }\n{ \"_id\": 3, \"len\": 22.360679774997898 }<\/code><\/pre>\n
\n
AggregateCommand.subtract(value: Expression[]): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u5c06\u4e24\u4e2a\u6570\u5b57\u76f8\u51cf\u7136\u540e\u8fd4\u56de\u5dee\u503c\uff0c\u6216\u5c06\u4e24\u4e2a\u65e5\u671f\u76f8\u51cf\u7136\u540e\u8fd4\u56de\u76f8\u5dee\u7684\u6beb\u79d2\u6570\uff0c\u6216\u5c06\u4e00\u4e2a\u65e5\u671f\u51cf\u53bb\u4e00\u4e2a\u6570\u5b57\u8fd4\u56de\u7ed3\u679c\u7684\u65e5\u671f\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression[]<\/h3>\n
[<expression1>, <expression2>]<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.subtract([<expression1>, <expression2>])\n<\/code><\/pre>\n
\u53c2\u6570\u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u6570\u5b57\u6216\u65e5\u671f\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 scores \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ \"_id\": 1, \"max\": 10, \"min\": 1 }\n{ \"_id\": 2, \"max\": 7, \"min\": 5 }\n{ \"_id\": 3, \"max\": 6, \"min\": 6 }\n<\/code><\/pre>\n
\u6c42\u5404\u4e2a\u8bb0\u5f55\u7684 max \u548c min \u7684\u5dee\u503c\u3002\uff1a<\/p>\n
const $ = db.command.aggregate\ndb.collection('scores').aggregate()\n  .project({\n    diff: $.subtract(['$max', '$min'])\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ \"_id\": 1, \"diff\": 9 }\n{ \"_id\": 2, \"diff\": 2 }\n{ \"_id\": 3, \"diff\": 0 }<\/code><\/pre>\n
\n
AggregateCommand.trunc(value: Expression<number>): Object<\/h2>\n
\n  \u652f\u6301\u7aef\uff1a\u5c0f\u7a0b\u5e8f 2.7.4, \u4e91\u51fd\u6570 0.8.1, Web\n<\/p><\/blockquote>\n
\u805a\u5408\u64cd\u4f5c\u7b26\u3002\u5c06\u6570\u5b57\u622a\u65ad\u4e3a\u6574\u5f62\u3002<\/p>\n
\u53c2\u6570<\/h2>\n
value: Expression<number><\/h3>\n
number<\/p>\n
\u8fd4\u56de\u503c<\/h2>\n
Object<\/h3>\n
API \u8bf4\u660e<\/h2>\n
\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n
db.command.aggregate.trunc(<number>)\n<\/code><\/pre>\n
\u53c2\u6570\u53ef\u4ee5\u662f\u4efb\u610f\u89e3\u6790\u4e3a\u6570\u5b57\u7684\u8868\u8fbe\u5f0f\u3002<\/p>\n
\u793a\u4f8b\u4ee3\u7801<\/h2>\n
\u5047\u8bbe\u96c6\u5408 scores \u6709\u5982\u4e0b\u8bb0\u5f55\uff1a<\/p>\n
{ \"_id\": 1, \"value\": 1.21 }\n{ \"_id\": 2, \"value\": 3.83 }\n{ \"_id\": 3, \"value\": -4.94 }\n<\/code><\/pre>\n
const $ = db.command.aggregate\ndb.collection('scores').aggregate()\n  .project({\n    int: $.trunc('$value')\n  })\n  .end()\n<\/code><\/pre>\n
\u8fd4\u56de\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
{ \"_id\": 1, \"value\": 1 }\n{ \"_id\": 2, \"value\": 3 }\n{ \"_id\": 3, \"value\": -4 }<\/code><\/pre>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
AggregateCommand.abs(value: Expression<number&g […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[182398],"tags":[],"class_list":["post-184853","post","type-post","status-publish","format-standard","hentry","category-mini-program"],"_links":{"self":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts\/184853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/comments?post=184853"}],"version-history":[{"count":0,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts\/184853\/revisions"}],"wp:attachment":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/media?parent=184853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/categories?post=184853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/tags?post=184853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}