Method getList

packages/db/src/services/event.service.ts:1079–1180

({
    projectId,
    profileId,
    cursor,
    filters,
    limit = 50,
    startDate,
    endDate,
  }: IEventServiceGetList & {
    limit?: number;
    startDate?: Date;
    endDate?: Date;
  })

  }

  async getList({
    projectId,
    profileId,
    cursor,
    filters,
    limit = 50,
    startDate,
    endDate,
  }: IEventServiceGetList & {
    limit?: number;
    startDate?: Date;
    endDate?: Date;
  }) {
    const date = cursor || new Date();
    const query = this.query({
      projectId,
      profileId,
      limit,
      orderBy: 'created_at',
      filters,
      select: {
        event: {
          deviceId: true,
          profileId: true,
          id: true,
          name: true,
          createdAt: true,
          country: true,
          city: true,
          os: true,
          browser: true,
          path: true,
          sessionId: true,
        },
        profile: {
          id: true,
          firstName: true,
          lastName: true,
          avatar: true,
          isExternal: true,
        },
      },
      where: {
        event: (q) => {
          if (startDate && endDate) {
            q.where('created_at', 'BETWEEN', [
              startDate ?? new Date(date.getTime() - 1000 * 60 * 60 * 24 * 3.5),
              cursor ?? endDate,
            ]);
          } else {
            q.where('created_at', '<', date);
          }
          if (filters) {
            q.rawWhere(
              Object.values(
                getEventFiltersWhereClause(filters, projectId)
              ).join(' AND ')
            );