Hibernate Criteria query to display notnull values of a field A whose corresponding field B values are null
I have two fields in a Table job_open and job_close. I want to create a hibernate criteria query to retrieve only those fields from job_open field that are not null and their corresponding value in job_close field is null.

Any Help would be useful
Hibernate Criteria query to display notnull values of a field A whose corresponding field B values are null
===

I have two fields in a Table job_open and job_close. I want to create a hibernate criteria query to retrieve only those fields from job_open field that are not null and their corresponding value in job_close field is null.

Any Help would be useful