Question

136

Sequelize: Include.where filtering by a 'parent' Model attribute

rated 0 times [ 138] [ 2] / answers: 1 / hits: 71042 / 9 Years ago, tue, may 5, 2015, 12:00:00

I have two Models related, Catalog and ProductCategory. The latter has a composed PK, 'id, language_id'.
Here are the models simplified:

var Catalog = sequelize.define("Catalog", {

id: {

  type: DataTypes.INTEGER,

  primaryKey: true,

  autoIncrement: true

},

user_id: {

  type: DataTypes.INTEGER,

  allowNull: false

},

product_category_id: {

  type: DataTypes.STRING(7)

},

language_id: {

  type: DataTypes.INTEGER

},  

... more stuff ...

}



var ProductCategory = sequelize.define("ProductCategory", {

id: {

  type: DataTypes.STRING(7),

  primaryKey: true

},

language_id: {

  type: DataTypes.INTEGER,

  primaryKey: true

},

... more stuff ...

}



Catalog.belongsTo(models.ProductCategory, {foreignKey: 'product_category_id'});

I'm trying to include some info from ProductCategory table related to Catalog, but ONLY when the language_id matches.

At the moment I'm getting all the possible matches from both tables.
This is the query right now:

Catalog.find({where:

    {id: itemId},

    include: {

        model: models.ProductCategory, 

        where: {language_id: /* Catalog.language_id */}

    }

})

Is there a way to use an attribute from Catalog to filter the include where both models have the same language?

By the way, I've also tried changing the where clause, without any consecuence:

where: {'ProductCategory.language_id': 'Catalog.language_id'}

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

jaredsages

Add To Favorites

Follow

Total Points: 273

Total Questions: 97

Total Answers: 105

Location: French Southern and Antarctic Lands

Member since Fri, Jan 6, 2023

1 Year ago

jaredsages questions

1 Unexpected reserve word 'await'

Tue, Aug 17, 21, 00:00, 3 Years ago

1 React.JS App MODULE_NOT_FOUND error on 'npm start'

Sun, Jan 10, 21, 00:00, 3 Years ago

1 Next-Pwa not working on production server such as Nginx

Fri, Oct 23, 20, 00:00, 4 Years ago

1 How to call Vue instance in chrome console, if he created in a separated file

Mon, Aug 31, 20, 00:00, 4 Years ago

1 Record voice with recorder.js and upload it to python-flask server, but WAV file is broken

Mon, Feb 3, 20, 00:00, 4 Years ago

View All

answered 9 Years ago annaliese · Accepted Answer

Sequelize provides an extra operator $col for this case so you don't have to use sequelize.literal('...') (which is more a hack).

In your example the usage would look like this:

Catalog.find({where:

    {id: itemId},

    include: {

        model: models.ProductCategory, 

        where: {

          language_id: {$col: 'Catalog.language_id'}

        }

    }

})