All,

I have a few searches that need to include softly-deleted records. I have not been able to figure out how to do this. I've tried both Criteria and HQL queries. I've also tried tricking the query by adding "or is_deleted=1" but that doesn't work, either. Any predicate I supply seems to be and'ed with the @Where value. Is it possible to find deleted records?

I have some doubts about the requirement in the first place, so I might push back a bit more. Even if I can get rid of this requirement, it seems I might run in to issues in the future when I try to create a new record whose natural key conflicts with a deleted record.

I'm using 3.6.9.

thanks

John