DisBot
    Preparing search index...

    Interface TicketsDelegate<ExtArgs, GlobalOmitOptions>

    interface TicketsDelegate<
        ExtArgs extends InternalArgs = DefaultArgs,
        GlobalOmitOptions = {},
    > {
        fields: TicketsFieldRefs;
        aggregate<T extends TicketsAggregateArgs<DefaultArgs>>(
            args: Subset<T, TicketsAggregateArgs>,
        ): Prisma.PrismaPromise<GetTicketsAggregateType<T>>;
        count<T extends TicketsCountArgs<DefaultArgs>>(
            args?: Subset<T, TicketsCountArgs>,
        ): Prisma.PrismaPromise<
            T extends Record<"select", any>
                ? T<T>["select"] extends true
                    ? number
                    : {
                        [P in string | number | symbol]: P extends keyof TicketsCountAggregateOutputType
                            ? TicketsCountAggregateOutputType[P<P>]
                            : never
                    }
                : number,
        >;
        create<T extends TicketsCreateArgs<DefaultArgs>>(
            args: SelectSubset<T, TicketsCreateArgs<ExtArgs>>,
        ): Prisma__TicketsClient<
            GetFindResult<$TicketsPayload<ExtArgs>, T, GlobalOmitOptions>,
            never,
            ExtArgs,
            GlobalOmitOptions,
        >;
        createMany<T extends TicketsCreateManyArgs<DefaultArgs>>(
            args?: SelectSubset<T, TicketsCreateManyArgs<ExtArgs>>,
        ): Prisma.PrismaPromise<BatchPayload>;
        createManyAndReturn<T extends TicketsCreateManyAndReturnArgs<DefaultArgs>>(
            args?: SelectSubset<T, TicketsCreateManyAndReturnArgs<ExtArgs>>,
        ): Prisma.PrismaPromise<
            GetFindResult<$TicketsPayload<ExtArgs>, T, GlobalOmitOptions>[],
        >;
        delete<T extends TicketsDeleteArgs<DefaultArgs>>(
            args: SelectSubset<T, TicketsDeleteArgs<ExtArgs>>,
        ): Prisma__TicketsClient<
            GetFindResult<$TicketsPayload<ExtArgs>, T, GlobalOmitOptions>,
            never,
            ExtArgs,
            GlobalOmitOptions,
        >;
        deleteMany<T extends TicketsDeleteManyArgs<DefaultArgs>>(
            args?: SelectSubset<T, TicketsDeleteManyArgs<ExtArgs>>,
        ): Prisma.PrismaPromise<BatchPayload>;
        findFirst<T extends TicketsFindFirstArgs<DefaultArgs>>(
            args?: SelectSubset<T, TicketsFindFirstArgs<ExtArgs>>,
        ): Prisma__TicketsClient<
            GetFindResult<$TicketsPayload<ExtArgs>, T, GlobalOmitOptions>,
            null,
            ExtArgs,
            GlobalOmitOptions,
        >;
        findFirstOrThrow<T extends TicketsFindFirstOrThrowArgs<DefaultArgs>>(
            args?: SelectSubset<T, TicketsFindFirstOrThrowArgs<ExtArgs>>,
        ): Prisma__TicketsClient<
            GetFindResult<$TicketsPayload<ExtArgs>, T, GlobalOmitOptions>,
            never,
            ExtArgs,
            GlobalOmitOptions,
        >;
        findMany<T extends TicketsFindManyArgs<DefaultArgs>>(
            args?: SelectSubset<T, TicketsFindManyArgs<ExtArgs>>,
        ): Prisma.PrismaPromise<
            GetFindResult<$TicketsPayload<ExtArgs>, T, GlobalOmitOptions>[],
        >;
        findUnique<T extends TicketsFindUniqueArgs<DefaultArgs>>(
            args: SelectSubset<T, TicketsFindUniqueArgs<ExtArgs>>,
        ): Prisma__TicketsClient<
            GetFindResult<$TicketsPayload<ExtArgs>, T, GlobalOmitOptions>,
            null,
            ExtArgs,
            GlobalOmitOptions,
        >;
        findUniqueOrThrow<T extends TicketsFindUniqueOrThrowArgs<DefaultArgs>>(
            args: SelectSubset<T, TicketsFindUniqueOrThrowArgs<ExtArgs>>,
        ): Prisma__TicketsClient<
            GetFindResult<$TicketsPayload<ExtArgs>, T, GlobalOmitOptions>,
            never,
            ExtArgs,
            GlobalOmitOptions,
        >;
        groupBy<
            T extends TicketsGroupByArgs<DefaultArgs>,
            HasSelectOrTake extends 0 | 1,
            OrderByArg extends
            
                    | {
                        orderBy: | TicketsOrderByWithAggregationInput
                        | TicketsOrderByWithAggregationInput[];
                    }
                    | {
                        orderBy?: | TicketsOrderByWithAggregationInput
                        | TicketsOrderByWithAggregationInput[];
                    },
            OrderFields extends
                | "Id"
                | "GuildId"
                | "ChannelId"
                | "CreatedAt"
                | "ChannelType"
                | "TranscriptChannelId"
                | "OnlyClaimMode"
                | "UserDMWhenCloseMessageTemplateId"
                | "WithTicketFeedback"
                | "TicketFeedbackChannelId"
                | "AutoAssignHandler"
                | "AutoReplyMessageTemplateId"
                | "AutoCloseAction"
                | "OldTicketCategoryId"
                | "SendTranscriptToUser"
                | "TicketSetupId"
                | "TicketId"
                | "ClosedAt"
                | "IsClosed"
                | "ThreadId"
                | "LastMessageId"
                | "IsClaimed"
                | "IsArchived"
                | "ArchiveMessageId"
                | "UserWhoHasClaimedId"
                | "IsLocked"
                | "TicketOwnerId"
                | "AddedMemberIds"
                | "TranscriptHTML"
                | "TranscriptJSON"
                | "TicketNotes"
                | "IsAutoDone"
                | "CloseActionReason",
            ByFields extends Prisma.TicketsScalarFieldEnum,
            ByValid extends 0 | 1,
            HavingFields extends string | number | symbol,
            HavingValid,
            ByEmpty extends 0 | 1,
            InputErrors,
        >(
            args: {
                [key in string | number | symbol]: key extends keyof TicketsGroupByArgs<
                    DefaultArgs,
                >
                    ? T[key<key>]
                    : never
            } & OrderByArg & InputErrors,
        ): {} extends InputErrors
            ? GetTicketsGroupByPayload<T>
            : Prisma.PrismaPromise<InputErrors>;
        update<T extends TicketsUpdateArgs<DefaultArgs>>(
            args: SelectSubset<T, TicketsUpdateArgs<ExtArgs>>,
        ): Prisma__TicketsClient<
            GetFindResult<$TicketsPayload<ExtArgs>, T, GlobalOmitOptions>,
            never,
            ExtArgs,
            GlobalOmitOptions,
        >;
        updateMany<T extends TicketsUpdateManyArgs<DefaultArgs>>(
            args: SelectSubset<T, TicketsUpdateManyArgs<ExtArgs>>,
        ): Prisma.PrismaPromise<BatchPayload>;
        updateManyAndReturn<T extends TicketsUpdateManyAndReturnArgs<DefaultArgs>>(
            args: SelectSubset<T, TicketsUpdateManyAndReturnArgs<ExtArgs>>,
        ): Prisma.PrismaPromise<
            GetFindResult<$TicketsPayload<ExtArgs>, T, GlobalOmitOptions>[],
        >;
        upsert<T extends TicketsUpsertArgs<DefaultArgs>>(
            args: SelectSubset<T, TicketsUpsertArgs<ExtArgs>>,
        ): Prisma__TicketsClient<
            GetFindResult<$TicketsPayload<ExtArgs>, T, GlobalOmitOptions>,
            never,
            ExtArgs,
            GlobalOmitOptions,
        >;
        [K: symbol]: {
            meta: { name: "Tickets" };
            types: {
                fields: TicketsFieldRefs;
                operations: {
                    aggregate: {
                        args: TicketsAggregateArgs<ExtArgs>;
                        result: Optional<AggregateTickets>;
                    };
                    count: {
                        args: TicketsCountArgs<ExtArgs>;
                        result: number | Optional<TicketsCountAggregateOutputType>;
                    };
                    create: {
                        args: TicketsCreateArgs<ExtArgs>;
                        result: PayloadToResult<$TicketsPayload>;
                    };
                    createMany: {
                        args: TicketsCreateManyArgs<ExtArgs>;
                        result: BatchPayload;
                    };
                    createManyAndReturn: {
                        args: TicketsCreateManyAndReturnArgs<ExtArgs>;
                        result: PayloadToResult<
                            $TicketsPayload<DefaultArgs>,
                            RenameAndNestPayloadKeys<$TicketsPayload<DefaultArgs>>,
                        >[];
                    };
                    delete: {
                        args: TicketsDeleteArgs<ExtArgs>;
                        result: PayloadToResult<$TicketsPayload>;
                    };
                    deleteMany: {
                        args: TicketsDeleteManyArgs<ExtArgs>;
                        result: BatchPayload;
                    };
                    findFirst: {
                        args: TicketsFindFirstArgs<ExtArgs>;
                        result: PayloadToResult<
                            $TicketsPayload<DefaultArgs>,
                            RenameAndNestPayloadKeys<$TicketsPayload<DefaultArgs>>,
                        >;
                    };
                    findFirstOrThrow: {
                        args: TicketsFindFirstOrThrowArgs<ExtArgs>;
                        result: PayloadToResult<$TicketsPayload>;
                    };
                    findMany: {
                        args: TicketsFindManyArgs<ExtArgs>;
                        result: PayloadToResult<
                            $TicketsPayload<DefaultArgs>,
                            RenameAndNestPayloadKeys<$TicketsPayload<DefaultArgs>>,
                        >[];
                    };
                    findUnique: {
                        args: TicketsFindUniqueArgs<ExtArgs>;
                        result: PayloadToResult<
                            $TicketsPayload<DefaultArgs>,
                            RenameAndNestPayloadKeys<$TicketsPayload<DefaultArgs>>,
                        >;
                    };
                    findUniqueOrThrow: {
                        args: TicketsFindUniqueOrThrowArgs<ExtArgs>;
                        result: PayloadToResult<$TicketsPayload>;
                    };
                    groupBy: {
                        args: TicketsGroupByArgs<ExtArgs>;
                        result: Optional<TicketsGroupByOutputType>[];
                    };
                    update: {
                        args: TicketsUpdateArgs<ExtArgs>;
                        result: PayloadToResult<$TicketsPayload>;
                    };
                    updateMany: {
                        args: TicketsUpdateManyArgs<ExtArgs>;
                        result: BatchPayload;
                    };
                    updateManyAndReturn: {
                        args: TicketsUpdateManyAndReturnArgs<ExtArgs>;
                        result: PayloadToResult<
                            $TicketsPayload<DefaultArgs>,
                            RenameAndNestPayloadKeys<$TicketsPayload<DefaultArgs>>,
                        >[];
                    };
                    upsert: {
                        args: TicketsUpsertArgs<ExtArgs>;
                        result: PayloadToResult<$TicketsPayload>;
                    };
                };
                payload: $TicketsPayload<ExtArgs>;
            };
        };
    }

    Type Parameters

    Indexable

    Index

    Properties

    Fields of the Tickets model

    Methods

    • Group by Tickets. Note, that providing undefined is treated as the value not being there. Read more here: https://pris.ly/d/null-undefined

      Type Parameters

      • T extends TicketsGroupByArgs<DefaultArgs>
      • HasSelectOrTake extends 0 | 1
      • OrderByArg extends
            | {
                orderBy: | TicketsOrderByWithAggregationInput
                | TicketsOrderByWithAggregationInput[];
            }
            | {
                orderBy?: | TicketsOrderByWithAggregationInput
                | TicketsOrderByWithAggregationInput[];
            }
      • OrderFields extends
            | "Id"
            | "GuildId"
            | "ChannelId"
            | "CreatedAt"
            | "ChannelType"
            | "TranscriptChannelId"
            | "OnlyClaimMode"
            | "UserDMWhenCloseMessageTemplateId"
            | "WithTicketFeedback"
            | "TicketFeedbackChannelId"
            | "AutoAssignHandler"
            | "AutoReplyMessageTemplateId"
            | "AutoCloseAction"
            | "OldTicketCategoryId"
            | "SendTranscriptToUser"
            | "TicketSetupId"
            | "TicketId"
            | "ClosedAt"
            | "IsClosed"
            | "ThreadId"
            | "LastMessageId"
            | "IsClaimed"
            | "IsArchived"
            | "ArchiveMessageId"
            | "UserWhoHasClaimedId"
            | "IsLocked"
            | "TicketOwnerId"
            | "AddedMemberIds"
            | "TranscriptHTML"
            | "TranscriptJSON"
            | "TicketNotes"
            | "IsAutoDone"
            | "CloseActionReason"
      • ByFields extends Prisma.TicketsScalarFieldEnum
      • ByValid extends 0 | 1
      • HavingFields extends string | number | symbol
      • HavingValid
      • ByEmpty extends 0 | 1
      • InputErrors

      Parameters

      Returns {} extends InputErrors
          ? GetTicketsGroupByPayload<T>
          : Prisma.PrismaPromise<InputErrors>

      // Group by city, order by createdAt, get count
      const result = await prisma.user.groupBy({
      by: ['city', 'createdAt'],
      orderBy: {
      createdAt: true
      },
      _count: {
      _all: true
      },
      })