NestJS - Database with TypeORM
You want to create a repository method that returns users created in the last 7 days. Which approach correctly implements this in a custom repository?
You want to create a repository method that returns users created in the last 7 days. Which approach correctly implements this in a custom repository?
hard📝 Application Q8 of 15
Step-by-Step Solution
Solution:
Step 1: Understand date filtering in repository
QueryBuilder allows complex queries like filtering by date ranges directly in the repository.Step 2: Evaluate options
Using find() without conditions and filtering later is inefficient; findOneBy() returns one record; raw SQL in controller breaks separation of concerns.Final Answer:
Use QueryBuilder with a where clause filtering createdAt >= current date minus 7 days -> Option AQuick Check:
Use QueryBuilder for date range queries in repository [OK]
Quick Trick: Use QueryBuilder for complex date filters in repositories [OK]
Common Mistakes:
- Filtering data outside repository instead of query
- Using findOneBy() for multiple records
- Putting SQL in controller
Master "Database with TypeORM" in NestJS
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore NestJS Quizzes