I've just got a simple question about placing a WHERE clause in the hbm.xml file. I am trying to retrieve all the records based on dates to see if they are active.

ie
<set name="orgUnitUsers"
table="USER_ACCESS"
lazy="true"
inverse="false"
access="field"
where="EFF_DATE < SYSDATE AND END_DATE > SYSDATE">
<key column="ORGANISATIONAL_UNIT_ID" />
<one-to-many class="uk.gov.ch.chips.common.user.User" />
</set>


I get a problem when I put the < into the line as it ends the string statement. I tried &lt; but this caused an error.

Anyone know what I need to put here for the query to work?

Thanks

Why would "<" end the string? Is it some kind of odd editor you're using? That where clause should work fine.