Does prisma 2 support group by, and complex queries ?

[al-ani]

I have two concerns about Prisma 2 which are:

1- Prisma 1 does not support "Group By", so does Prisma 2 support now?

2- Does Prisma 2 support complex query?, like this below query.

  query {
  users(where: { id:"server1"  }) {
      id
      name
      lastMonthPaid  <-----------I want to use this variable in sub query
      offers{
        books (where:{date: lastMonthPaid}){<----------this is the sub query
          dealprice
        }
      }
    }
  }

[ryands17]

Hi @al-ani

1- Prisma 1 does not support "Group By", so does Prisma 2 support now?

As for aggregations, you can track the issue here

2- Does Prisma 2 support complex query?, like this below query.

Regarding sub-queries, you can follow this answer given here that shows how you can perform sub-queries via select and include.
We will be adding that to the docs soon and you can follow that issue here

Do let me know if this solves your query :)

[aymannav6]

thanks