How to get an array of joined table in sequelize in findAll()

How to get an array of joined table in sequelize in findAll()

Feb 20 '24 Comments: 1 Answers: 0

0

  const response = await OrderDal.findAll({
  where: { buyerId: userId }
  attributes: { exclude: ['outcomeId', 'programId'] },
  include: [
    {
      model: User,
      as: 'buyerOrders',
      attributes: ['name'],
    },
    {
      model: User,
      as: 'sellerOrders',
      attributes: ['name'],
    },
    {
      model: Outcome,
      attributes: ['title'],
    },
    {
      model: ProgramOrder,
      as: 'programOrders',
      attributes: ['orderId', 'totalUnitsValue', 'CPO', 'PPO'],

…

Open Full Question