This is one way of writing a Hibernate filter. We have to define a filter first using @FilterDef as a global annotation, meaning that it can be applied anywhere in the code.
Then we apply the filter to where ever we want using @Filter and then we need to enable the filter in the session.
The reason for the filter is that when I do A.getstateTransitions() I want the list of B’s returned to be filtered.
@FilterDef(name=”myfilter”, defaultCondition=”TRANSITION_DATE > trunc (sysdate)”)
class A{
@OneToMany(…)
@Filter(name=”myfilter”)
private List<B> stateTransitions;}
class B{
@NotNull
@Column (name=”TRANSITION_DATE”, columnDefinition=”DATE”)
private Calendar transitionDate;}
Using:
org.hibernate.Session session = (Session) entityManager.getDelegate();
session.enableFilter(“myfilter”);
query.getResultList() // returns list of A’s where B.stateTransitions are after now.
Filters can have parameters but I didn’t need one here.
