mmaillot
08/18/2020, 2:35 PMUUIDTable
`Intervention`with a child: val foreignEnterprise = reference("foreign_enterprise", ForeignEnterprises.id)
. I want to get the foreign enteprise for an intervention. I have the InterventionUuid
. How can I do ? In SQL, I do: SELECT foreign_enterprise.* from foreign_enterprise, intervention WHERE intervention.foreign_enteprise_id = foreign_enterprise_id AND intervention.id ='`INPUT_UUID`'.ForeignEnterprises.join(
Interventions,
JoinType.INNER
)
.slice(ForeignEnterprises.columns)
.select { Interventions.id eq interventionId.value }
.map { ForeignEnterprises.toModel(it) }
.first()
Joel
08/18/2020, 5:47 PMForeignEnterprises innerJoin Interventions
should also be valid. The reference
you've added ties them together.mmaillot
08/19/2020, 8:18 AMForeignEnterprises.innerJoin(Interventions)
.slice(ForeignEnterprises.columns)
.select { Interventions.id eq interventionId.value }
.map { ForeignEnterprises.toModel(it) }
.first()
Is it what you mean ?