https://kotlinlang.org logo
#exposed
Title
# exposed
j

Jgafner

07/14/2021, 12:01 PM
Hi probably a dummy question and I am missing something - how do I translate this query in the code:
Copy code
select *
from regression_notifications rn
         join notification_checks nc on rn.id = nc.regression_id
         join check_issues ci on nc.id = ci.check_id
where ci.status = "Open"
I tried:
Copy code
RegressionTable.join(CheckTable.join( IssueTable,JoinType.INNER),JoinType.INNER).select { IssueTable.status eq "Open" }
but it return different results thanks
b

Bogdan

07/15/2021, 2:38 PM
Copy code
Table
	.join(Table1, JoinType.INNER, additionalConstraint = { //if needed })
	.join(Table2, JoinType.INNER, additionalConstraint = { //if needed })
	.select { Table1.id eq 10 }
4 Views