javascript - Sequelize find soft deleted rows - Stack Overflow

admin管理员组

文章数量:1208155

I'm trying to get some rows from database that are soft deleted AND some that are not, but it's not working for me.

Model.findAll({
    'where': {
        cond: 'xxx'
    },
    include: [Model2],
    paranoid: false
}).then(function (rows) {
    // do something
}).catch(function (err) {
    // do something
});

How can I do it?

I'm trying to get some rows from database that are soft deleted AND some that are not, but it's not working for me.

Model.findAll({
    'where': {
        cond: 'xxx'
    },
    include: [Model2],
    paranoid: false
}).then(function (rows) {
    // do something
}).catch(function (err) {
    // do something
});

How can I do it?

• javascript
• node.js
• sequelize.js

Share Improve this question Follow asked Sep 18, 2015 at 19:04 kecal909kecal909 16311 gold badge22 silver badges1010 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 23

The query you have should include instances of Model that have been soft-deleted, but won't include instances of Model2 that are soft-deleted.

To get the soft-deleted Model2 instances, you'll also need the paranoid: false option within the include:

Model.findAll({
    'where': {
        cond: 'xxx'
    },
    include: [{
        model: Model2,
        paranoid: false
    }], 
    paranoid: false
}).then(function (rows) {
    // do something
}).catch(function (err) {
    // do something
});

This doesn't seem to be in the documentation, but I tried it and it worked.

本文标签： javascriptSequelize find soft deleted rowsStack Overflow