node.js - 在 Sequelize 中使用左连接复制行

Question

我在 Sequelize postgress by limit 和 offset 中使用 LEFT JOIN。
当我更改下一页的限制和偏移量时，最后一页的结束行重复
在下一页的第一行。

关系:

 service.hasMany(servicePicture, { foreignKey: 'ServiceID', targetKey: 'ServiceID' });
 servicePicture.belongsTo(service, { foreignKey: 'ServiceID', targetKey: 'ServiceID' });

我使用:

models.Service.findAll({
attributes: attributes,
where: whereClause,

include:     {

    model: models.ServicePicture ,
    attributes:[
        'ServicePictureID',
        'ServicePicturePath'  
    ],
    where: {IsDeleted : false},
    required:false,

   } ,

subQuery:false,
offset: startRowIndex, 
limit: recordCount,

 })
 .then(serviceModels =>{
resolve(serviceModels);})

Answer 1

在查询中使用 distinct:true

models.Service.findAll({
attributes: attributes,
where: whereClause,

include:     {

    model: models.ServicePicture ,
    attributes:[
        'ServicePictureID',
        'ServicePicturePath'  
    ],
    where: {IsDeleted : false},
    required:false,

   } ,

subQuery:false,
offset: startRowIndex, 
limit: recordCount,
distinct:true // add this distinct here

 })
 .then(serviceModels =>{
resolve(serviceModels);})