YZ
Size: a a a
YZ
YZ
establishmentIds был массивом? сейчас только первый элемент туда попадает. Что-то уже 2 часа в доках лажу и не могу найти... const res = await Organization.findAndCountAll({
attributes: [[Organization.sequelize.col('Establishments.id'), 'EstablishmentsIds']],
include: [{
model: Establishment,
}],
});VH
сейчас только первый элемент туда попадаетVH
YZ
YZ
VH
VH
YZ
VH
const res = await Organization.findAndCountAll({
attributes: [[
Organization.sequelize.literal('array_agg("Establishments.id")'), 'ids',
]],
include: [{
model: Establishment,
}],
});Establishments.id не существует, хотя если вместо поставить id то выдает такое:SequelizeDatabaseError: column reference "id" is ambiguous (candidates: Organization.id, Establishments.id)YZ
YZ
YZ
YZ
VH
YZ
YZ
VH
SELECT "Organization"."id", "Establishments"."id" AS "EstablishmentsIds", "Establishments"."id" AS "Establishments.id", "Establishments"."title" AS "Establishments.title", "Establishments"."imageUrl" AS "Establishments.imageUrl", "Establishments"."email" AS "Establishments.email", "Establishments"."phone" AS "Establishments.phone", "Establishments"."ssid" AS "Establishments.ssid", "Establishments"."createdAt" AS "Establishments.createdAt", "Establishments"."updatedAt" AS "Establishments.updatedAt", "Establishments"."organizationId" AS "Establishments.organizationId" FROM "Organizations" AS "Organization" LEFT OUTER JOIN "Establishments" AS "Establishments" ON "Organization"."id" = "Establishments"."organizationId"
YZ
YZ