Stack Overflow em Português Asked by Gustavo Benevenuto on January 2, 2022
Fiz duas tabelas, Usuario
1 : N Produto
Fiz um inner join com o TypeOrm, porém estava vindo um array vazio, então peguei a query que ele estava gerando para analisar melhor. Quando joguei a query no Dbeaver funcionou perfeitamente, os dados vieram certinhos, porém, somente quando chamo pela aplicação ela vem vazia, alguém poderia me ajudar??
Query gerada quando uso o getQuery()
SELECT "Produto"."nome", "usuario"."nome" FROM "tb_produto" "Produto" INNER JOIN "tb_usuario" "usuario" ON "usuario"."id" = "Produto"."id_usuario"
const produtos = await createQueryBuilder(Produto)
.innerJoinAndSelect('tb_usuario', 'usuario','usuario.id = Produto.id_usuario')
.select('Produto.nome, usuario.nome')
.getMany();
Espero que já tenha conseguido resolver o problema. Mas para aqueles que cairem nessa pergunta, tente substituir getMany() por getRawMany()
Para mais informações: https://typeorm.io/#/select-query-builder
Answered by Gustavo Souza on January 2, 2022
2 Asked on December 30, 2021 by temstocles-ara
banco de dados entidade relacionamento modelagem modelo relacional
3 Asked on December 30, 2021 by problemtico
2 Asked on December 30, 2021 by igor-ptz
2 Asked on December 30, 2021
2 Asked on December 30, 2021 by djalmafreestyler
1 Asked on December 30, 2021 by danrley-alencar
1 Asked on December 30, 2021 by luan-luiz
1 Asked on December 30, 2021 by alexsandro-andrade
2 Asked on December 30, 2021 by gustavo-bium-donadon
1 Asked on December 30, 2021
1 Asked on December 30, 2021 by everton
4 Asked on December 28, 2021 by angelfmf
6 Asked on December 28, 2021 by ivan-veloso
2 Asked on December 28, 2021 by nielsen-rick
4 Asked on December 28, 2021 by user93774
1 Asked on December 28, 2021
3 Asked on December 28, 2021 by cleriston-martins-cardoso
1 Asked on December 28, 2021
Get help from others!
Recent Answers
Recent Questions
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP