TypeORM, Query entity based on relation property

typeorm
Daniel Santos picture Daniel Santos · Aug 25, 2019 · Viewed 7.3k times · Source

I would like to query an entity based on a related property, for instance:

const x = await repo.findOne({ name: 'foo', parent: { name: 'foo' }});

but it aways returns a null when I query by its related parent

I alread added : relations: ['parent'], already set relation as {eager:true}

When I Query by parent: {id: X} it works. but I must query by its name.

What should I do to get this query working in TypeORM

It would be similar to:

select * from entity inner join parent ... where entity.name = 'foo' and parent.name = 'foo'

Answer

Aleksi picture Aleksi · Aug 25, 2019

find/findOne doesn't allow filtering by nested relation properties. Go for QueryBuilder instead with something like

const x = await repo.createQueryBuilder("foo")
    .innerJoinAndSelect("foo.parent", "parent")
    .where("parent.name = :name", { name })
    .getOne()

Check here for a similar question.

Related questions

TypeError: Class extends value undefined is not a function or null

I am getting the following error when trying to create these entities. TypeError: Class extends value undefined is not a function or null I am assuming this has something to do with circular dependencies, but how is that supposed to …

Read More
TypeORM subqueries

Based on typeORM docs on using subqueries, there are explained how to create subqueries. Example: const qb = await getRepository(Post).createQueryBuilder("post"); const posts = qb .where("post.title IN " + qb.subQuery().select("user.name").from(User, "user").where("user.registered = :…

Read More
TypeORM upsert - create if not exist

Does TypeORM include some functionnality to avoid this : let contraption = await thingRepository.findOne({ name : "Contraption" }); if(!contraption) // Create if not exist { let newThing = new Thing(); newThing.name = "Contraption" await thingRepository.save(newThing); contraption = newThing; } Something like : let contraption = await thingRepository.…

Read More