There is not any `offset` on query to mongo callback about query-to-mongo HOT 2 CLOSED

I think the confusion is related to how/when I first developed and used this package. I was using mongoskin to execute queries. I see mongoskin hasn't been updated since 2016 -- Like I'm one to talk 😄 .

At the time, mongoskin exposed a find method that accepted the criteria and options as-is. db.Kitten.find(criteria, options).toArray(cb), for example.

I doubt the current version of mongoskin still support the options as-is. I believe it exposed find from a mongodb library. But it was years ago -- I think it was before MongoDB 3.0.

Depending on the library you are using you'll likely need to cherry pick values from the returned options rather than passing it as-is.

My quick take on using a more up-to-date libarary (Mongoose 6.0.0) with results from query-to-mongo:

const mongoose = require('mongoose')
await mongoose.connect('mongodb://localhost:27017/test')
const kittySchema = new mongoose.Schema({
  name: String,
  age: Number,
})
const Kitten = mongoose.model('Kitten', kittySchema)

const queryString = "name=john&age>21&fields=name,age&sort=name,-age&offset=10&limit=10"
var q = q2m(queryString)

var query = Kitten.find(q.criteria)
if (q.options) {
  if (q.options.fields) query = query.projection(q.options.fields)
  if (q.options.sort) query = query.sort(q.options.sort)
  if (q.options.skip) query = query.skip(q.options.skip)
  if (q.options.limit) query = query.limit(q.options.limit)
}
const list = await query.exec()

Caveat: I have not run this example -- you may experience some turbulence.

from query-to-mongo.

After doing some more research, I've found that the find() option exposed by MongoDB NodeJS Driver does support the options as returned by query-to-mongo.

• The Find method: https://mongodb.github.io/node-mongodb-native/4.4/interfaces/FindOptions.html#skip
• The FindOptions structure: https://mongodb.github.io/node-mongodb-native/4.4/interfaces/FindOptions.html
• The skip option: https://mongodb.github.io/node-mongodb-native/4.4/interfaces/FindOptions.html#skip

But I did fix the problem you pointed out in the document: offset in returned object should be skip.

from query-to-mongo.