How can I limit many-to-many relationships on Sequelize

Question

I have following associations:

M:N relationship table

ProductCategory.hasMany(Product, { foreignKey: 'productId' });
ProductCategory.hasMany(Category, { foreignKey: 'categoryId', required: true });
  
   Category.belongsToMany(Product, {
      through: {
        model: ProductCategory,
      },
      otherKey: 'productId',
      foreignKey: 'categoryId',
    });


Product.belongsToMany(Category, {
  through: {
    model: ProductCategory,
    unique: false,
  },
  otherKey: 'categoryId',
  foreignKey: 'productId',
});

When I invoke following method CategoryModel.findAll({ include: [ {model: ProductModel, limit: 1} ] }); I get something like this:

"Only HasMany associations support include.separate"

Anyone knows how can I handle this and limit include (many-to-many) relationship? If I remove limit everything works that's expected, I get categories with their associated products, but I want to limit products.

I will appreciate any help, regards.

user_14345973 · Answer

Sequelize still doesn't support limit on belongsToMany relations:

const categories = await CategoryModel.findAll();
const categoriedProductModels = await categories.getProductModels({limit:1});

Alternative questions are 1,2

user_10323582 · Answer

CategoryModel.findAll({ 
              include: [ {model: ProductModel} ] , 
              limit: 1 
      });

This will help you.

For more details check this link https://sequelize.org/v5/manual/models-usage.html

How can I limit many-to-many relationships on Sequelize

2 Answers