LA
Model.find({
...
include: {
model: AnotherModel,
limit:1
})Size: a a a
2020 January 02
YE
Okey i'll try tknks
LA
Yulaf Ezmesi
wait, why is limit inside brackets? { }
LA
You could put "limit" inside the same object, rather than next to it
LA
{
where: {
PK:
},
include: {
...
},
limit: 1
}LA
It's easier to read for me like this :P
YE
{
where: {
PK:
},
include: {
...
},
limit: 1
}İ will share tomarrow my style
YE
You're best way i think
LA
Perfect :)
2020 January 03
LA
Yulaf did it work friend?
YE
Yes dude @luisazcuaga its work but i cant use es6 express
YE
Asyc await and promise all didnt work :(
LA
Well that is not sequelize related, I’ll PM you
2020 January 05
LA
I have an interesting doubt
LA
I have 3 tables.
Users, Sensors and Alerts
I want to findAll Users including Sensors and Alerts
I want to show the included tables count of the elements and a sum of a column in Alerts.
Desired output ->
Users, Sensors and Alerts
I want to findAll Users including Sensors and Alerts
I want to show the included tables count of the elements and a sum of a column in Alerts.
Desired output ->
User has 2 sensors, 3 alerts and the sum is 500.LA
My attempt was this, but no matter what I write inside COUNT and SUM, it itterates n*m times on the elements. Where n is the number of sensors and m is the number of alerts.
LA
three alerts (actual data)
LA
4 sensors
