NestJS - Database with TypeORM
How do you correctly add a WHERE clause to filter users with age greater than 18 using QueryBuilder in NestJS?
How do you correctly add a WHERE clause to filter users with age greater than 18 using QueryBuilder in NestJS?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Use parameterized query
.where('user.age > :age', { age: 18 }) correctly uses a parameter:agewith a value of 18.Step 2: Check alias usage
.where('age > :age', { age: 18 }) misses the alias 'user' before 'age', which is required.Step 3: Validate other options
.where('user.age > 18') uses a raw string without parameters (less safe), and D checks equality, not greater than.Final Answer:
.where('user.age > :age', { age: 18 }) -> Option BQuick Check:
Always use parameters with alias in WHERE clauses [OK]
Quick Trick: Use alias and parameters in WHERE clauses [OK]
Common Mistakes:
- Omitting alias in the condition
- Using raw values instead of parameters
- Using wrong comparison operators
Master "Database with TypeORM" in NestJS
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore NestJS Quizzes