Typeorm - 左连接并仅选择关系实体

Question

我有命令:

                .leftJoinAndSelect("permission.user", "user")
                .where("permission.stream = :stream", {stream: req.params.id})
                .getMany();

这给了我这个输出:

[
  Permission {
    id: 51,
    user: User { nick: 'jmat', password: 'jmat', email: '<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="761c1b1702361819021e1f18115815191b" rel="noreferrer noopener nofollow">[email protected]</a>' }
  }
]

我只想要这样的输出:

[
User { nick: 'jmat', password: 'jmat', email: '<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="2b41464a5f6b45445f4342454c05484446" rel="noreferrer noopener nofollow">[email protected]</a>' }
  }
]

我尝试在 where 和 getMany 之间的代码中添加这样的行，但它不起作用。也尝试过使用joinAndMap，但也没有解决。

.select(['user'])
.select(['permission.user']

感谢您的帮助

Answer 1

尝试使用 select 和 getRawMany 选项

.leftJoinAndSelect("permission.user", "user")
.where("permission.stream = :stream", {stream: req.params.id})
.select("user")
.getRawMany();