I use this query and its work , but i

Question

I use this query and its work , but i

dont know why its work ?😂
let result = await this.models.A.findAndCountAll({
where:{"id": A.id },
limit: per_page,
offset: page * per_page,
attributes: {
//include
exclude:['id','updatedAt','deletedAt']
},
order: [
[ { model: this.models.B, as: 'B' }, 'createdAt', 'DESC' ]
],
include:[{
model:this.models.B,
as:"B",
attributes: {
exclude:['id' ,'updatedAt','deletedAt']
},
required: true,

}],

});

0

27.02.2020

3 ответов

7 просмотров

Amirala Автор вопроса

i dont use count , A is counting B without group or count

0

27.02.2020

Пользователь 61a12

tried your code.. I can't get it to work..also findAndCountAll selects everything and then count using JavaScript..so I don't see it's effectiveness as you can still select all data and output the array length

0

27.02.2020

Пользователь 61a12 · Accepted Answer

Пользователь 61a12

are you sure you are getting the count of model B not of A?

0

27.02.2020

Похожие чаты

I use this query and its work , but i

3 ответов

Похожие вопросы