unknown top level operator: $orderby

Question

We've a node.js + mongoose app running on Ubuntu linux servers spun on DigitalOcean VPS.

One of our mongoose queries have a text index with the following operators:

and looks like this:

db.sampleCollection.find({
  $text: {
    $search: userInput
  },
  $lte: {
    expired: (new Date()).addDays(30)
  },
  $limit: 9,
  $orderby: {
    postedAt: -1
  }
})

which throws this error:

unknown top level operator: $orderby

Solutions already considered:

Mongoose uses $set by default, however we're not using that operator in our query
This solution considers aggregation, however we need it for find function
This solution seems to be for array fields, however we need solution for non-array indexes
We're not mixing operators, as said in this solution

Need inputs on how to fix this.

@RolandStarke This query is not running on mongo shell anyways and ours is MongoDB server version: `3.4.3` — Zameer Ansari, Jan 01 '18 at 10:59
Did you try `$sort` instead of `$orderby` ? Look this solution: https://stackoverflow.com/questions/5825520 it might help you. — Pierre R-A, Jan 01 '18 at 11:32
@PierreR-A Thanks for the inputs, will try to implement this soon and get back — Zameer Ansari, Jan 02 '18 at 05:56

score 3 · Answer 1 · answered Jan 01 '18 at 15:56

3

Query modifiers like $orderBy are no longer supported:

Starting in v3.2, the query “meta” operators are deprecated in the mongo shell. In the mongo shell, use the cursor methods instead.

As suggested by the docs, use the cursor methods like sort and limit instead:

db.sampleCollection.find({
  $text: {
    $search: userInput
  },
  $lte: {
    expired: (new Date()).addDays(30)
  }
})
.sort({
    postedAt: -1
})
.limit(9);

answered Jan 01 '18 at 15:56

JohnnyHK

305,182
66
621
471

2

What about doing a query from javascript with the `mongodb` library? – Jim Apr 20 '20 at 20:10

score -1 · Answer 2 · answered Jan 01 '18 at 14:01

Check your mongodb version orderby has been deprecated since v3.2

$orderby Deprecated in the mongo Shell since v3.2
In the mongo shell,use cursor.sort() instead.

https://docs.mongodb.com/manual/reference/operator/meta/orderby/

db.sampleCollection.find({
    $text   : {
        $search: userInput
    },
    $lte    : {
        expired: (new Date()).addDays(30)
    },
    $limit  : 9,
    $sort: {
        postedAt: -1
    }
})

unknown top level operator: $orderby

2 Answers2

Linked