[v5]how to orderBy preload column ?

[BlazingCode]

there is User , Document Model

I want it to work with

Document.query().preload('user').orderBy('user.name','desc')

i know if use join

const documents= await Document
  .query()
  .preload('user')
  .join('users', 'users.id', 'document.user_id')
  .orderBy('users.name', 'desc')
  .select('document.*')

Lazy Loading method load() need findOrFail || find function so i can`t use it

Is there any way without using join or orderByRaw?

or how can use lazy loding way?

[sergefabre]

Hello
are you test
Document.query().preload('user', (user) => user.orderBy(name,'desc')) ?

[BlazingCode]

thanks for the answer

I have already tested the query you suggested.

what i want
Sort the documents based on the columns of the user model.

The relationship between user and document is a 1:N relationship

The above query is not suitable for my situation

[sergefabre]

in your model, you use the relation hasMany ?

[sergefabre]

Document.query().preload('user', (u) => u.orderBy('name','desc'))

[RomainLanz]

Hey @BlazingCode! 👋🏻

I recommend writing the query in SQL first without relying on the ORM.
Once you have a query that meets your requirements, we can consider how to integrate it into the ORM syntax.