Hi probably a dummy question and I am missing some...
# exposed
j
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
Copy code
Table
	.join(Table1, JoinType.INNER, additionalConstraint = { //if needed })
	.join(Table2, JoinType.INNER, additionalConstraint = { //if needed })
	.select { Table1.id eq 10 }