Counting scalar field | Prisma | Page 1

serene iris Dec 5, 2023, 9:48 AM

#

Hi everyone,
Is there an API for counting scalar fields AND relations in the same query ?

For exemple, in the following I'd like a query wher I get posts counts + colors count

model User { id Int @id @default(autoincrement()) email String @unique colors String[] posts Post[] }

Is this possible?

Thanks!

plain cipher Dec 5, 2023, 11:44 AM

#

Hi @serene iris 👋

Have you looked at the documentation on count relations?

Prisma

Aggregation, grouping, and summarizing (Concepts)

Use Prisma Client to aggregate, group by, count, and select distinct.

serene iris Dec 5, 2023, 1:19 PM

#

Hi @plain cipher !

#

Yes I did, but there's no mention of counting scalar fields

serene iris Dec 7, 2023, 2:50 PM

#

@plain cipher up 🙂

serene iris Dec 8, 2023, 8:36 AM

#

So I know I can just fetch the whole array and count it, but isn't there an API for that ? So I would not need to fetch an array of hundreds of entries ?

#

@plain cipher

plain cipher Dec 8, 2023, 8:53 AM

#

Hi @serene iris, can you please clarify the exact count you want. Do you want a count of the relation posts and a separate count of the scalar list colors?

#Counting scalar field