NestJS TypeORM如何正确类型的或有条件,在查询?

0

的问题

我目前有这样的代码,获得我的结果

rolesCanAssign = await this.rolesRepository.find({
            

where: {
    VALCompany: user.VALCompany,
},

但我需要添加一个或操作者在这里和我想像这样做

where: [{VALCompany:user.VALCompany},{isNull(VALCompany)}]

我得到一个错误说我期待的一个'{'. 因此目前使用以下但我喜欢的类型很像前面的例子

代码目前的作品对我说:

where: 'VALCompany IS NULL or VALCompany IN (' + user.VALCompany + ')'
1

最好的答案

1

问题是在第二部分,你应该做的:

where: [{VALCompany:user.VALCompany},{VALCompany:isNull()}]
2021-11-23 08:03:41

其他语言

此页面有其他语言版本

Русский
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................