JPQL Query With Condition -

JPQL Query With Condition -

could 1 please help me how write query in jpql. concern how interpret status

and tfnoop.end_date(+)

in below query in jpql.

i trying left outer bring together parent , kid table status on kid table. if status on kid table doesn't meet, still need rows parent table. here below sql query trying for. help appreciated.

select sc.*,tfnoop oop_scripts sc, tfn_oop_scripts tfnoop sc.oop_script_id=tfnoop.oop_script_id(+) , sc.script_code='h131' , tfnoop.end_date(+)>=sysdate

jpql