typeorm-graphql-loader
typeorm-graphql-loader copied to clipboard
Ordering of sub relations
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```