lazy-loading.ts

   const { data, pagination } =
      await this.data.transactions.findAllWithPagination(
        {
          ...filterQuery,
          isRevenue: false,
          reconTransactionType: Not(In(excludedTransactionType)),
        },
        {
          relationFields: ['user'],
          selectFields: this.selectFields,
        },
      );


// in the findAllWithPagination method


    const baseFindOptions = {
      where: { ...query },
      order: {
        createdAt: sort,
      },
      take: perpage,
      skip: page * perpage - perpage,
      ...(options?.relationFields
        ? { relations: options.relationFields }
        : null),  // lazy loading in typeORM
      ...(options?.selectFields ? { select: options.selectFields } : []),
      ...(options?.relationIds ? { loadRelationIds: true } : false),
      // cache: true,
    };

    const [data, total] = await this._entity.findAndCount(baseFindOptions);