[4.1] Using query result column as a where in a .with

[rodolphonetto]

Hi guys, in the code below I need to get only the forms who has the same solicitation type as the solicitation I'm asking for... I did it with two querys but I think I can do it with one, how can I would do? Thanks :)

    const solicitation_type = await Model.query().where('id', id).first()
    const solicitation = await Model.query()
      .where('id', id)
      .with('category')
      .with('status')
      .with('crop_year')
      .with('states')
      .with('cities')
      .with('steps.forms', (builder) => {
        builder
          .isUsable()
          .where('solicitation_type_id', solicitation_type.solicitation_type_id)

continues...