[Solved] Given this Remix loader code using Prisma:const users = await prisma.user.findMany({ where: { active: true }, select: { id: true, name: true } });What will be the shape of the returned data? | Remix

Remix - Performance

Given this Remix loader code using Prisma:

const users = await prisma.user.findMany({ where: { active: true }, select: { id: true, name: true } });

What will be the shape of the returned data?

AAn array of all user objects including inactive users

BAn array of objects with only 'id' and 'name' fields for active users

CAn array of objects with all fields for active users

DAn error because 'select' cannot be used with 'where'

Step-by-Step Solution

Solution:

Step 1: Understand 'where' and 'select' usage
'where' filters active users; 'select' limits fields to 'id' and 'name'.
Step 2: Determine returned data shape
Only active users are returned, each with just 'id' and 'name' fields.
Final Answer:
An array of objects with only 'id' and 'name' fields for active users -> Option B
Quick Check:
Filter + select = limited fields for filtered users [OK]

Quick Trick: Use 'select' to limit fields after filtering with 'where' [OK]

Common Mistakes:

MISTAKES

Master "Performance" in Remix

9 interactive learning modes - each teaches the same concept differently

More Remix Quizzes

Given this Remix loader code using Prisma: