Hi does anyone know where to find good documentation for use of hibernate's @FilterDef notation?

Any examples on how to use it would be greatly appreciated.

Thank you

Vaughn

The annotations ref doc should have some rudimentary explanation
The core ref doc a more detailed one
The unit test suite has some live examples
and Java Persistence with Hibernate describe them too.

Thank you for the reply

Do you know the URLs for them?


How would I filter out dates?

For example

@Entity
@FilterDef(name="getRiskWithoutArchiveDateSet" )
@Filters( {
@Filter(name="withoutArchive", condition="archiveDateTime = null")

} )

Thanks again.

Did you search for them?

http://www.hibernate.org/5.html

All I could find is the following

When the collection use an association table as a relational representation, you might want to apply the filter condition to the association table itself or to the target entity table. To apply the constraint on the target entity, use the regular @Filter annotation. However, if you wan to target the association table, use the @FilterJoinTable annotation.

@OneToMany
@JoinTable
//filter on the target entity table
@Filter(name="betweenLength", condition=":minLength <= length and :maxLength >= length")
//filter on the association table
@FilterJoinTable(name="security", condition=":userlevel >= requredLevel")
public Set<Forest> getForests() { ... }


So I did the following om my risk class:

public class Risk extends BaseEntity {


@JoinColumn(name = "objective", referencedColumnName = "id")
@ManyToOne(fetch = FetchType.EAGER)
@FilterJoinTable(name="withoutArchiveDate", condition="archiveDateTime is null")
private Objective objective;


no luck so far

Regards vaughn

There is not association table in your case, a simple filter should work, but filter on ToOne associations should be placed on the associated entity, not on the association.
can you open a JIRa issue so that I update the doc?

Hi
Emmanuel

Thank for the reply

How do you post a JIRA Issue?

I have placed the filter on an objective object which has many risk objects.


@Cache(usage = CacheConcurrencyStrategy.READ_WRITE)
@FilterJoinTable(name="withoutArchive", condition="archiveDateTime is null")
@OneToMany(mappedBy = "objective", fetch = FetchType.LAZY)
private Set<Risk> risks;


Which gives me an error.

Thanks Vaughn

http://opensource.atlassian.com/projects/hibernate/secure/Dashboard.jspa

I was refering to
@Filter
@Entity
public class Objective