Template
single collection
multiple collections
mgodatagen
update
indexe
explain
Stage
Database
bson
mgodatagen
[{"grade":"Silver"},{"grade":"Gold"},{"grade":"Bronze"}]
Query
db.collection.aggregate([{$addFields:{"customGradeOrder":{$indexOfArray:[["Gold","Silver","Bronze"],"$grade"]}}},{$sort:{customGradeOrder:1}}])
Result