Skip to content
This repository has been archived by the owner on Nov 12, 2023. It is now read-only.

Ordering of sub relations #28

Open
AaronNGray opened this issue Apr 17, 2022 · 0 comments
Open

Ordering of sub relations #28

AaronNGray opened this issue Apr 17, 2022 · 0 comments

Comments

@AaronNGray
Copy link

Given an Order and Items relational query, how do I order the items by a field as well as the orders ?

    return loader
        .loadEntity(Order, "order")
        .info(info)
        .order({'order.date': 'DESC'})
        .loadMany();
@ObjectType()
@Entity()
export class Order extends BaseEntity {

    @Field((type) => Int)
    @PrimaryGeneratedColumn()
    id: number;

    @FieldI(type) => String)
    @Column()
    text: string;

    @Field((type) => Date)
    @Column()
    date: Date;

    @Field((type) => [Item], { nullable: true })
    @OneToMany((type) => Item, item => item.order)
    items Item[];
}

@ObjectType()
@Entity()
export class Item extends BaseEntity {

    @Field((type) => Int)
    @PrimaryGeneratedColumn()
    id: number;

    @Field()
    @Column()
    text: string;

    @Field()
    @Column()
    _number: number;

    @Field((type) => Post)
    @ManyToOne((type) => Order, (order) => order.items)
    @JoinColumn({ name: 'order_id' })
    item: Item;
};


I want to be able to add the equivalent to a ```.order({{'item._number': 'ASC'})``` to order items within orders by ```_number```
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant