Jgafner
07/14/2021, 12:01 PMselect *
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:
RegressionTable.join(CheckTable.join( IssueTable,JoinType.INNER),JoinType.INNER).select { IssueTable.status eq "Open" }
but it return different results
thanksBogdan
07/15/2021, 2:38 PMTable
.join(Table1, JoinType.INNER, additionalConstraint = { //if needed })
.join(Table2, JoinType.INNER, additionalConstraint = { //if needed })
.select { Table1.id eq 10 }