Get the sum of quantities grouped by an Id that is not in the current table

#javascript #node #sequelize #prisma

Dec 3 '22 Comments: 1 Answers: 0

I have three models that look something like this:

const Reagent = sequelize.define('reagent', {
    name: {
      type: DataTypes.STRING
      allowNull: false,
    },
    ...
  })
  const Box = sequelize.define('box', {
    code: {
      type: DataTypes.STRING,
      allowNull: false,
      unique: true,
    },
    quantity: {
      type: DataTypes.INTEGER,
      allowNull: false,
    },
    ...
  })

  const BoxActivity = sequelize.define('boxActivity',

…

Open Full Question