[Solved] Given this QueryBuilder snippet, what is the output?const count = await this.orderRepository.createQueryBuilder('order') .where('order.status = :status', { status: 'shipped' }) .getCount(); | NestJS

NestJS - Database with TypeORM

Given this QueryBuilder snippet, what is the output?

const count = await this.orderRepository.createQueryBuilder('order')
  .where('order.status = :status', { status: 'shipped' })
  .getCount();

ATotal number of orders ignoring status

BArray of orders with status 'shipped'

CNumber of orders with status 'shipped'

DUndefined because getCount() is invalid

Step-by-Step Solution

Solution:

Step 1: Understand getCount() method
getCount() returns the number of records matching the query.
Step 2: Analyze the where clause
It filters orders where status equals 'shipped'.
Final Answer:
Number of orders with status 'shipped' -> Option C
Quick Check:
getCount() returns count of filtered records [OK]

Quick Trick: Use getCount() to get number of matching rows [OK]

Common Mistakes:

Master "Database with TypeORM" in NestJS

9 interactive learning modes - each teaches the same concept differently

More NestJS Quizzes

Given this QueryBuilder snippet, what is the output?