Lucid: use where inside of with

[vrwebdesign]

I have a Model and I want to use where inside it.
for example I have a User Model and Post Model and I want to use this query

.query()
.with("user")
.where("user.username","like","%john%")

and my result must be All post that owner username is john

[webdevian]

See Adding Runtime Constraints

const posts = await Post
  .query()
  .with('user', (builder) => {
    builder.where('username', 'like', '%john%')
  })
  .fetch()

[webdevian]

That's wrong sorry, I think you'll need whereHas

const posts = await Post
  .query()
  .whereHas('user', (builder) => {
    builder.where('username', 'like', '%john%')
  })
  .fetch()

[vrwebdesign]

tnx @webdevian for your answer.
know how can orderBy whit username in the same example.