Hi probably a dummy question and I am missing something - how do I translate this query in the code:...

# exposed

[Jgafner]

Hi
probably a dummy question and I am missing something - how do I translate this query in the 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:

RegressionTable.join(CheckTable.join( IssueTable,JoinType.INNER),JoinType.INNER).select { IssueTable.status eq "Open" }

but it return different results
thanks

[Bogdan]

Table
	.join(Table1, JoinType.INNER, additionalConstraint = { //if needed })
	.join(Table2, JoinType.INNER, additionalConstraint = { //if needed })
	.select { Table1.id eq 10 }