I am new to relations and typeorm. And now have some troubles with them. And now a little confused. Is it possible in typeorm sort relation by id or createdDate without mapping it and to have limit elements? My code example below:

person.entity

@Entity()
export class Person {
  @PrimaryGeneratedColumn()
  public id!: number;

  @Column({ type: 'varchar', length: 120 })
  public firstName: string;

  @Column({ type: 'varchar', length: 120 })
  public lastName: string;

  @Column({ type: 'varchar', length: 13 })
  public phone: string;

  @Column({ type: 'varchar', length: 500 })
  public place: string;

  @Column({ type: 'boolean', default: false })
  public isDeleted: boolean;

  @OneToMany(() => Event, (event) => event.person, {
    onDelete: 'SET NULL',
  })
  public events: Event[];

  @CreateDateColumn({ type: 'timestamp' })
  public createdAt!: Date;

  @UpdateDateColumn({ type: 'timestamp' })
  public updatedAt!: Date;
}

event.entity

@Entity()
export class Event {
  @PrimaryGeneratedColumn()
  public id!: number;

  @ManyToOne(() => Person, (person) => person.id, {
    onDelete: 'CASCADE',
  })
  public person!: Person;

  @ManyToOne(() => User, (user) => user.id, {
    onDelete: 'CASCADE',
  })
  public user!: User;

  @CreateDateColumn({ type: 'timestamp' })
  public createdAt!: Date;

  @UpdateDateColumn({ type: 'timestamp' })
  public updatedAt!: Date;
}

My code for sorting

  // get persons and sort events
  public async getALlPersons(): Promise<Person[]> {
    return this.repository
      .find({
        relations: ['events'],
        order: {
          createdAt: 'DESC',
        },
      })
      .then((persons) =>
        persons.map((person) => {
          person.events.sort((a, b) => b.id - a.id);
          return person;
        }),
      );
  }

And how to limit the number of events per person, for example I want to show only 10 events?

Thanks