MongoDB排序文档不起作用,尝试对数据进行排序。

huangapple go评论99阅读模式
英文:

Mongo db Sort document not working, trying to order data

问题

我正在尝试对数据进行排序

  1. try{
  2. if(typeof order_data == 'undefined')
  3. {
  4. var column_name = '_id';
  5. var column_sort_order = 'desc';
  6. }
  7. else
  8. {
  9. var column_index = req.query.order[0]['column'];
  10. var column_name = req.query.columns[column_index]['data'];
  11. var column_sort_order = req.query.order[0]['dir'];
  12. }
  13. console.log(column_name);
  14. console.log(column_sort_order);
  15. const data_arr= await EAVerificationModel.find({'adminid':adminID},{applicantname:1,_id:1}).sort({column_name:column_sort_order}).limit(limit).skip(startIndex).exec();
  16. console.log(data_arr);
  17. tried different different methods like asc,desc,1,-1 still didnt work,
  18. can anyone tell me what im doing wrong
英文:

I'm trying to sort data

  1. try{
  2. if(typeof order_data == 'undefined')
  3. {
  4. var column_name = '_id';
  5. var column_sort_order = 'desc';
  6. }
  7. else
  8. {
  9. var column_index = req.query.order[0]['column'];
  10. var column_name = req.query.columns[column_index]['data'];
  11. var column_sort_order = req.query.order[0]['dir'];
  12. }
  13. console.log(column_name);
  14. console.log(column_sort_order);
  15. const data_arr= await EAVerificationModel.find({'adminid':adminID},{applicantname:1,_id:1}).sort({column_name:column_sort_order}).limit(limit).skip(startIndex).exec();
  16. console.log(data_arr);

tried different different methods like asc,desc,1,-1 still didnt work,
can anyone tell me what im doing wrong

答案1

得分: 0

尝试创建一个处理排序的对象:

  1. try {
  2. let sortObj = {};
  3. if (order_data) {
  4. const column_index = req.query.order[0]['column'];
  5. const column_name = req.query.columns[column_index]['data'];
  6. const column_sort_order = req.query.order[0]['dir'];
  7. sortObj[column_name] = column_sort_order;
  8. } else {
  9. sortObj = { _id: 'desc' };
  10. }
  11. const data_arr = await EAVerificationModel.find(
  12. { adminid: adminID },
  13. { applicantname: 1, _id: 1 }
  14. )
  15. .sort(sortObj)
  16. .limit(limit)
  17. .skip(startIndex)
  18. .exec();
  19. console.log(data_arr);
  20. } catch (e) {}
英文:

Try to create an object to handle your sorting:

  1. try {
  2. let sortObj = {};
  3. if (order_data) {
  4. const column_index = req.query.order[0]['column'];
  5. const column_name = req.query.columns[column_index]['data'];
  6. const column_sort_order = req.query.order[0]['dir'];
  7. sortObj[column_name] = column_sort_order;
  8. } else {
  9. sortObj = { _id: 'desc' };
  10. }
  11. const data_arr = await EAVerificationModel.find(
  12. { adminid: adminID },
  13. { applicantname: 1, _id: 1 }
  14. )
  15. .sort(sortObj)
  16. .limit(limit)
  17. .skip(startIndex)
  18. .exec();
  19. console.log(data_arr);
  20. } catch (e) {}

huangapple
  • 本文由 发表于 2023年1月10日 15:22:02
  • 转载请务必保留本文链接:https://go.coder-hub.com/75066684.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定