How to filter an entity in hibernate with hibernate filters

Question

I need to filter an entity in a list of objects, for example:

public class Student {

    private int id;

    private List<Course> courses;

}

public class Course {

    private int id;

    private String name;

    private float note;

    private Classroom classroom;

}

public class Classroom {

    private int id;

    private String classroom;

}

How to obtain a student object with a list of courses with only notes greater than 70, and located in classroom 23 (for example)?

Is there a way to use the name of the entity instead of the one of the column of the database?

Or how do I associate with sql the alias generated by hibernate for the entity?

I attach a link from the hibernate filters: https://docs.jboss.org/hibernate/orm/5.0/manual/en-US/html/ch19.html

Have you tried any configuration yourself? Maybe you can post it and lets see whats wrong with it. Did you get any errors etc. — Maciej Kowalski
– Maciej Kowalski, Commented Jan 24, 2017 at 12:11
I just want to know if it can be filtered by the java entity, not by the database entity. — Jason Glez
– Jason Glez, Commented Jan 24, 2017 at 12:40
And how to do the join with the alias that generates hibernate dynamically. — Jason Glez
– Jason Glez, Commented Jan 24, 2017 at 12:43

Maciej Kowalski · Accepted Answer · 2017-01-24 12:56:48Z

5

Ok it think this should do the trick:

Entities

public class Student {

    private int id;

    @OneToMany(mappedBy = "student")
    @Filter(name = "defaultCoursesFilter")   
    private List<Course> courses;

}

@FilterDef(name = "defaultCoursesFilter"
                , defaultCondition=" notes > 70")
public class Course {

    private int id;

    private String name;

    private float note;

    @ManyToOne
    @Filter(name = "defaultClassromFilter")
    private Classroom classroom;

}


@FilterDef(name = "defaultClassromFilter"
                , defaultCondition=" id  = 23")
public class Classroom {

    private int id;

    private String classroom;

}

Before query

Session session = sessionFactory.getCurrentSession();
session.enableFilter("defaultCoursesFilter");
session.enableFilter("defaultClassromFilter");

// query

answered Jan 24, 2017 at 12:56

Maciej Kowalski

26.7k12 gold badges59 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jason Glez Over a year ago

Thank you very much, I'll try.

Ilya Lisov Over a year ago

This does not work for JPA queries

Collectives™ on Stack Overflow

How to filter an entity in hibernate with hibernate filters

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related