Argument of type '{ id: string; }' is not assignable to parameter of type 'FindOneOptions'

Question

Using mongodb by typeorm with nestjs - create crud rest api

When trying to get data by findone() with 'id' . getting below error

TS2345: Argument of type '{ id: string; }' is not assignable to parameter of type 'FindOneOptions'.
Object literal may only specify known properties, and 'id' does not exist in type 'FindOneOptions'.

Code:

 const result = await this.sellerRepository.findOne({ id });

Entity

@Entity('seller')
export class Seller {
  @ObjectIdColumn()
  id: ObjectID;
  @Column({
    type: 'string',
    nullable: false,
    name: 'product_name',
  })
  productName: string;
  @Column({
    name: 'short_desc',
  })
}

async findOne(id: string): Promise<Seller> {
    const result = await this.sellerRepository.findOne({ id });
    return result;
  }

It's being discussed on github at https://github.com/typeorm/typeorm/issues/8939 — Param Singh, Jul 02 '22 at 22:04

score 6 · Answer 1 · answered Jun 30 '22 at 18:16

6

You should use findOneBy

findOne(id: number): Promise<User> {
   return this.usersRepository.findOneBy({ id: id });
}

answered Jun 30 '22 at 18:16

Alberto lopez jimenez

107
2
9

Already tried with the above but did not work. It gives the same error message. – Vasanth Kumar Jul 01 '22 at 03:55

score 2 · Accepted Answer · answered Jul 01 '22 at 07:47

Here is my solution for above..

I used new ObjectID(id) and import { ObjectID } from 'mongodb';

if you get error like TS7016: Could not find a declaration file for module 'mongodb'

then follow below steps

create folder with 'typings'any at root project
create index.d.ts
add declare module 'mongodb';
add path of the index.d.ts in tsconfig.json file under typeRoots as below

"typeRoots": [ "./typings", "./node_modules/@types/" ]

sample code

import { ObjectID } from 'mongodb';
 async findOne(id: string): Promise<Seller> {
    const result = await this.sellerRepository.findOne(new ObjectID(id));
    return result;
  }

score 0 · Answer 3 · answered Jun 30 '22 at 16:47

0

You can use fithOneBy({id}) or findOne(id). The signature you provided does not match any method provided by TypeORM, so that's why Typescript complains.

You can always check all available options here and here.

answered Jun 30 '22 at 16:47

fmi21

485
3
15

Both tried but there is no use. I think typeorm gives this kind of error for mongodb – Vasanth Kumar Jul 01 '22 at 03:59
Are you sure the error remains the same? – fmi21 Jul 01 '22 at 06:43
yes..but got solution in another way..will post it...thank you for your response – Vasanth Kumar Jul 01 '22 at 07:05

score 0 · Answer 4 · answered Sep 14 '22 at 12:12

0

You can use exported types from 'typeorm' like this:

import { FindOptionsWhere } from 'typeorm';

...

const result = await this.sellerRepository.findOne({ id: id as FindOptionsWhere<Seller> });

answered Sep 14 '22 at 12:12

Hidayat Mammadov

83
1
6

Argument of type '{ id: string; }' is not assignable to parameter of type 'FindOneOptions'

4 Answers4