I have some audit fields in the db (create, modify, delete). So I never physically delete a record in the table but flag it as deleted. In the association mapping is there a way to filter out “deleted” records. In other words I don’t even want to pull them from the db. It wouldn’t be efficient.

Do I need to use IInterceptor.OnLoad() somehow

Thanks.

Are these columns in a separate table ? If not, filter should do the work. Can you post your mapping ?

session.filter filters a collection after it has already been pulled from the db. If the record is flagged as deleted I don't want to pull it from the db, or initialise any business entities.

Interceptor.OnLoad happens just before initialisation therefore this is also too late in the life cycle.

afaik the filter condition is added to the where clause, so the objects should not be pulled from the db. Am I really wrong there ?

I guess I should also add that this is a lazy load collection.

You can also apply a filter to a collection. I don't know, if lazy loading ignores the filter, but I don't think so. Can you post your mapping ?

If filter don't work for you, you can try adding a "where" clause to your collection mapping:



I would prefere the filter because you can enbable and disable it for each session as you need it.

Sorry I misunderstood what you meant by "filter" (there is a method with the same name). Thanks for the mapping example. I get you now.

Thanks.

You're welcome, hope that helps.