MongoDB 自定义排序
2021/11/3 19:13:37
本文主要是介绍MongoDB 自定义排序,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
Mongodb的排序函数sort()排序方式为:数字、中文首字母的顺序 升序(a-z)或者降序(z-a) 进行升序或者降序
db.getCollection('vuln').find({},{"_id":0,"severity":1,"vulnerability_id":1}).sort({"vulnerability_id":1})
但是部分类别为单词,例如,low,medium,high 根据这个排序,简单的办法,录入的时候使用int来标记对应类别,但是如果整改比较麻烦,或者其他接口已经使用,也可以使用聚合查询
db.vuln.aggregate( [ { "$match": { "$and": [ { "domain": "test.a.com" } ], "is_delete": false } }, { "$project": { "category": 1, "severity": { "$switch": { "default": 0, "branches": [ { "case": { "$eq": [ "$severity", "low" ] }, "then": 1 }, { "case": { "$eq": [ "$severity", "medium" ] }, "then": 2 }, { "case": { "$eq": [ "$severity", "high" ] }, "then": 3 }, { "case": { "$eq": [ "$severity", "critical" ] }, "then": 4 } ] } }, "is_delete": 1, "fix_status": 1, "title": 1, "definiteness": 1, "hash_id": 1 } }, { "$limit": 10 }, { "$skip": 0 }, { "$sort": { "severity": -1 } } ] )
这篇关于MongoDB 自定义排序的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-04-01got an unexpected keyword argument
- 2024-03-30维多利亚的秘密 golang入坑系统
- 2024-03-29mongodb sort by date
- 2024-03-29go swagger
- 2024-03-25mongodb cdc
- 2024-03-25how to use go in vscode
- 2024-03-22mongooseserverselectionerror: connect econnrefused ::1:27017
- 2024-03-21pymongo insert_many
- 2024-03-18projection mongodb
- 2024-03-14clickhouse-go