Hi there,

I am receiving an Unknown column error when adding a where clause to a collection

Here is the snippet of my collection:
<set name="activeItems" sort="unsorted" table="SUB_ITEM" where="STATUS='ACTIVE'">
<key column="PRODUCT_ID"/>
<one-to-many class="SubItem"/>
</set>

The column "STATUS" is part of the table ITEM and class Item. I would expect inheritance to find the column STATUS within the parent table.

If I change the column to something that is available in the child table then it all works fine.

Anyone have any thoughts?

Many thanks in advance.

Does anyone think this is a bug?