Hi,

I am mapping few tables using xml based associations. The Condition is such that, when I fetch the data, the data need to be fetched with the condition that the deleted column should be 0 in all the tables, but I can give condition on the main query, so, the cascade select, would apply the filter condition on the first table only. Is it possible somehow, that the condition is applied on all the mapped tables with cascade select.

Example :-

Entity 1 : Abc { field1, field2, deleted}
Entity 2 : XYZ { field3, field4, AbcMapped, deleted}
Relationship : Xyz is mapped to Abc with one-to-one mapping with fetch = "select"

Now, using a HQL, I can write.. "FROM Abc where deleted = false"
But, this will populate, all XYZ, but I want to add restrictions on XYZ also about deleted, and so on because there are many entity mapped.

Thanks in Advance..