Is there a way we can handle views with mongoose !?

[muhammadfaizan]

feature

What is the current behavior?
currently there is a plugin, but that only selects few fields, and doesn't work on multiple models

What is the expected behavior?
https://docs.mongodb.com/manual/reference/method/db.createView/#db.createView

using mongoDB 3.4

[vkarpov15]

Not sure what you mean by handling views. What's the plugin you're talking about?

Once a view is created, as far as mongoose is concerned it is just a read-only collection, so as long as you have a schema in mongoose you can query the view as you would any normal collection.

[muhammadfaizan]

I meant how can i create read only collection with mongoose, that is allowed by mongodb

[vkarpov15]

MyModel.connection.db.createCollection('myViewName', { viewOn: 'existingCollection', pipeline: [/* aggregation pipeline here */] }); http://mongodb.github.io/node-mongodb-native/2.2/api/Db.html#createCollection

[alzalabany]

so we can use createCollection to create a view. and redirect our model to use that view ?
im trying to implement something like soft delete where i have 2 collections 1_ all_data & 2nd active_only . and i want to from now on only use active only every where in app to hide deleted docs. but i cannt wrap my head how to do so with mongoose

[vkarpov15]

@alzalabany you would create 2 separate models, one that points to the allData collection and one that points to the activeData view. Use the third param to mongoose.model to specify the collection name http://mongoosejs.com/docs/api.html#mongoose_Mongoose-model

[fullStackDataSolutions]

It would be great if there was some kind of code example of this.