Order by query

[wiatrM]

Hello, thanks for great repository.

I'm wondering how ordering shall be implemented with this interface?

export interface OrderBy {
  [key: number]: -1 | 1;
}

How can I pass DTO to sort some column ASC/DESC in controller?

[Sairyss]

Hey

This interface is incorrect, I left it as number because I had some type overload issues and I forgot to fix it later.

TypeOrm interface looks like this:

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

Though interface is incorrect, it still works and you can order things. For example:

{ 
  params:{}, // some params here
  orderBy: { createdAt: -1 } 
}

^ This will order by createdAt DESC

[wiatrM]

Unfortunetly your solution still gives me an error:

[backend] ERROR in src/modules/tkd/use-cases/crud/tkd.crud.services.ts:89:24
[backend] TS2322: Type '{ id: number; }' is not assignable to type 'OrderBy'.
[backend]   Object literal may only specify known properties, and 'id' does not exist in type 'OrderBy'.
[backend]     87 |                 skip: paginateDto?.offset
[backend]     88 |             },
[backend]   > 89 |             orderBy: { id : 1 }
[backend]        |                        ^^^^^^
[backend]     90 |         });
[backend]     91 |     }

Im not very good at TypeScript generic, could you write me how to change the interface to support ordering?

Thanks in advance