MongoDB 排序数字字符串_mongo将字段转为数字排序范围

Sort sort = Sort.by(Sort.Direction.DESC, "pay_money");
query.with(sort)
  // String to Number sort
  .collation(Collation.parse("en_US").numericOrdering(true)); 
1
2
3
4

db.t_instance_order.find({}, {instance_type: 1, pay_money: 1})
  .sort({instance_type: 1, pay_money: -1})
  .collation({locale: "en_US", numericOrdering: true})
  .limit(10);
1
2
3
4