Query an Array of Embedded Documents

[CosmoFruit]

Issue type:

[X] question
[ ] bug report
[ ] feature request
[ ] documentation issue

Database system/driver:

[ ] cordova
[X] mongodb
[ ] mssql
[ ] mysql / mariadb
[ ] oracle
[ ] postgres
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo

TypeORM version:

[X] latest
[ ] @next
[ ] 0.x.x (or put your version here)

I have two entities:

export class User {
  @ObjectIdColumn()
  id: ObjectID;

  @Column()
  username: string;

  @Column()
  avatar: string;

  @Column(type => UserAccount)
  accounts: UserAccount[];

}

export class UserAccount {
  @ObjectIdColumn()
  id: ObjectID;

  @Index({unique: true})
  @Column()
  email: string;

  @Column()
  password_hash: string;
}

i try find user by account id:

  const u: User = await this.userRepository.findOne({
      where { accounts: {id: targetAccauntId}}
    })

but result is empty

how to right search in array of embedded entities?

[rosshadden]

I came to ask the same question. Though it's not just arrays, I can't figure out how to query nested objects either (if accounts was an object in your example instead of an array, for instance).

[lvao813]

I also encountered the same problem.

[atejadac]

I too have the same problem. Pretty hard to believe that TypeOrm doesn't offer that feature. Switching to Mongoose if this is not solved.

[Squallium]

Hi, I think this another issue could be related #1766

[rustamwin]

@CosmoFruit try it:

const u: User = await this.userRepository.findOne({
       "accounts.id": targetAccauntId
    })

or

const u: User = await this.userRepository.findOne({
       {accounts: {id: targetAccauntId}}
    })

[rustamwin]

See #3756

[kaczor6418]

@CosmoFruit try it:

const u: User = await this.userRepository.findOne({
       "accounts.id": targetAccauntId
    })

or

const u: User = await this.userRepository.findOne({
       {accounts: {id: targetAccauntId}}
    })

Sorry but both of this options are not working, they are returning only undefined

[MuhammadAbuSufian]

 const u: User = await this.userRepository.findOne({
      where: { "accounts.id" : targetAccauntId}
    })

[imnotjames]

For questions, please check out the community slack or check TypeORM's documentation page on other support avenues - cheers!

[hoangtrung17]

I tried this code for save data to test but accounts fill is null affter transform:
@Column(type => UserAccount) accounts: UserAccount[];
I think Mongoose is better than typeOrm to work with mongoDB

[adapolytech]

You can use aggregation it support nested document query and typeorm support aggregation
In the match stage you can specify field of nested document
$match : {
'account.id': id
}

[AbdallahShnaino]

const u: User = await this.userRepository.findOne({
where: { "accounts.id" : targetAccauntId}
})