Sort in other table by name about nestjs-typeorm-paginate HOT 8 CLOSED

I 'think' (not tried this) you can do this

order: {
   'userId': 'DESC',
   'photoName': 'DESC',
}

Might want to check typeorm docs https://typeorm.io/#/select-query-builder/adding-order-by-expression

from nestjs-typeorm-paginate.

I can sort by creating a query builder likes:

createQueryBuilder("photo")
    .innerJoin("photo.userId", "user")
    .orderBy("user.name")
    .getMany();


But in this case, I use paginate which could not write like this:
    return paginate<Photo>(this.photoRepository,
      { page, limit },
      { order: { "user.name": "DESC" } },
    );

Any solutions to these issues? Thank you very much.

from nestjs-typeorm-paginate.

@AnhLy new feature 😂 I'll add it in and release :p I've added it in but need tests

from nestjs-typeorm-paginate.

Thanks for your response, but I want to sort user name follow the alphabet, instead of userId.

from nestjs-typeorm-paginate.

Ok, after looking at the typeorm types it looks like this is not possible. Below you can see that the order object has to have a key that relates to the entity.

order?: {
     [P in keyof Entity]?: "ASC" | "DESC" | 1 | -1;
 };

In your case you don't really want to be using the repository, you probably want to be using the query builder. So I propose we add a new paginate method that will accept the queryBuilder (one method that takes queryBuilder || repository). This will enable you to do the above.

asyncf function paginate<Entity>(repoOrQueryBuilder: QueryBuilder | Repository<Entity>): Promise<Pagination<Entity>> {
   // check if repo or query builder 
  // return result
}

Type wise we'll end up with 2 defined methods

async function paginate<Entity>(repository: Repository<Entity>, options: IPaginationOptions, searchOptions: FindConditions<Entity> | FindManyOptions<Entity>): Proimse<Pagination<Entity>>;

async function paginate<Entity>(queryBuilder: QueryBuilder, options: IPaginationOptions): Promise<Entity>;

from nestjs-typeorm-paginate.

Thanks for taking the answer, here is the source code of the paginate, https://github.com/nestjsx/nestjs-typeorm-paginate/blob/master/src/paginate.ts, the paginate only receive the repository: Repository param. Or I miss something?

from nestjs-typeorm-paginate.

@bashleigh Oh thank you very very much.

from nestjs-typeorm-paginate.

will release in next version :)

from nestjs-typeorm-paginate.