#How to use prisma raw query in this prisma query?

1 messages · Page 1 of 1 (latest)

mental barn
#
   let quotation = await this.prisma.quotation.findUnique({
      where: { id },
      include: {
        statusHistory: {
          orderBy: {
            createdAt: 'desc',
          },
          take: 1,
        },
        byUser: {
          select: {
            firstName: true,
            lastName: true,
          },
        },
        project: {
          include: {
            ship: {
              select: {
                id: true,
                name: true,
                client: {
                  select: {
                    id: true,
                    name: true,
                  },
                },
              },
            },
          },
        },
        operations: {
          orderBy: {
            lineNumber: 'asc',
          },
          include: {
            activities: {
              select: {
                id: true,
                operationId: true,
                estimatedHours: true,
                actualHours: true,
                type: {
                  select: {
                    id: true,
                    name: true,
                    number: true,
                  },
                },
              },
            },
            materials: {
              select: {
                id: true,
                operationId: true,
                description: true,
                estimatedPrice: true,
                retailPrice: true,
              },
            },
          },
        },
      },
    });
``` 

```js
 const sql = Prisma.sql`SELECT (SUM("Activity"."estimatedHours") * "ActivityType"."multiplerValue") as "totalPrice" FROM "Activity" LEFT JOIN "ActivityType" ON "ActivityType"."id" = "Activity"."typeId" GROUP BY "Activity"."operationId", "ActivityType"."multiplerValue"`;
    const result = await this.prisma.$queryRaw`${sql}`;

I want to be able to use below raw query inside the first query

#

hhow to add it ?