Method getWorkspaceWithMembers

src/lib/db/query-optimizer.ts:275–354

* Get workspace with members in a single query

(teamId: string, workspaceSlug: string)

   * Get workspace with members in a single query
   */
  async getWorkspaceWithMembers(teamId: string, workspaceSlug: string): Promise<any> {
    this.trackQuery('workspaces', 'aggregateWithMembers');

    const db = this.client.db(databaseName);
    const workspaces = db.collection<WorkspaceDbSchema>('workspaces');

    const result = await workspaces.aggregate([
      {
        $match: {
          team: new ObjectId(teamId),
          'meta.slug': workspaceSlug
        }
      },
      {
        $lookup: {
          from: 'workspace_users',
          localField: '_id',
          foreignField: 'workspace',
          as: 'members'
        }
      },
      {
        $lookup: {
          from: 'users',
          let: { memberUserIds: '$members.user' },
          pipeline: [
            {
              $match: {
                $expr: { $in: ['$_id', '$$memberUserIds'] }
              }
            },
            {
              $project: {
                _id: 1,
                name: 1,
                email: 1,
                image: 1
              }
            }
          ],
          as: 'memberUsers'
        }
      },
      {
        $addFields: {
          members: {
            $map: {
              input: '$members',
              as: 'member',
              in: {
                $mergeObjects: [
                  '$$member',
                  {
                    user: {
                      $arrayElemAt: [
                        {
                          $filter: {
                            input: '$memberUsers',