Dear community,

I would appreciate it if someone could help me creating a HQL-Statement or the code to build up a correct criteria.

Here is what I want to express:

I have two identities: Article and ArticleModification. Each Article can have none or multiple ArticleModifiations.
I want to retrieve all Articles which do not have an ArticleModification or if they have one or more, every ArticleModification.LocksArticle must be false.

So something like:



Do you have an idea?

Thank you!

I sugest you to start by building the query using SQL. After you've done it you can use it in your app via CreateSqlQuery method. I don't think it can be done using criteria.

radu

It need not be by using a Criteria.
A HQL-Query would also be very nice!