Using Hibernate @Filter with Quarkus

[hablocher]

Hi folks!

I´m trying to use @Filter annotation with quarkus

For example, using these annotations at panache entity level :

@FilterDef(name = "organizationUnitFilter", 
parameters = @ParamDef(name = "organizationUnit", type = "string"))
@Filter(name = "organizationUnitFilter", condition = "organizationUnit = :organizationUnit")
@Entity
@Table(name = "person")
public class PersonDomain extends PanacheEntity {

And setting the filter in my Service component like this

Session session = em.unwrap(Session.class);
Filter filter = session.enableFilter("organizationUnitFilter");
filter.setParameter("organizationUnit", "ou=company");	
PersonDomain.findById(id);

But the filter don´t work... the generated SQL don´t include the filter in WHERE clause

What am I doing wrong please?

[hablocher]

Follow up ...

Works using JPQL, but dont work with PanacheEntity and @RepositoryRestResource, in the same @Service

	public PersonDomain find(Long id) {
		Optional<PersonDomain> person = personDomainRestRepository.findById(id);
		if (person.isPresent()) {
			return person.get();
		}
		return null;
	}
	
	public PersonDomain findWithQuery(Long id) {
		PersonDomain person;
		try {
			person = em.createQuery("select p from PersonDomain p where p.id = ?1", PersonDomain.class)
					.setParameter(1, id).getSingleResult();
		} catch (NoResultException e) {
			person = null;
		}
		return person;
	}
	
	public PersonDomain findWithPanache(Long id) {
		return PersonDomain.findById(id);
	}

[hablocher]

Found the problem!

hibernate.atlassian.net/browse/HHH-14772

[quarkus-bot[bot]]

/cc @Sanne (hibernate-orm), @gsmet (hibernate-orm), @yrodiere (hibernate-orm)