[Solved] What will the following QueryBuilder code return?const users = await this.userRepository.createQueryBuilder('user') .select(['user.id', 'user.name']) .where('user.isActive = :active', { active:... | NestJS

NestJS - Database with TypeORM

What will the following QueryBuilder code return?

const users = await this.userRepository.createQueryBuilder('user')
  .select(['user.id', 'user.name'])
  .where('user.isActive = :active', { active: true })
  .getMany();

AAn error because select needs all fields

BAn array of all user objects ignoring isActive

CA single user object with all fields

DAn array of user objects with only id and name where isActive is true

Step-by-Step Solution

Solution:

Step 1: Analyze select and where clauses
The select limits fields to id and name. The where filters users with isActive true.
Step 2: Understand getMany() behavior
getMany() returns an array of matching entities with selected fields.
Final Answer:
An array of user objects with only id and name where isActive is true -> Option D
Quick Check:
getMany() returns filtered array with selected fields [OK]

Quick Trick: getMany() returns array; select limits fields [OK]

Common Mistakes:

Thinking getMany() returns a single object
Assuming select must include all fields
Ignoring the where filter

Master "Database with TypeORM" in NestJS

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Perf

More NestJS Quizzes

What will the following QueryBuilder code return?

Step 1: Analyze select and where clauses

Step 2: Understand getMany() behavior

Final Answer:

Quick Check:

Want More Practice?