Using filters in getResultlist()

[pete007]

Hello,

I can't find an example, where filters/restrictions are used. I want to show a user only items, which have an attribute that matches his username. I want to do something like:

#{ identity.username == item.owner }

I remember some example or a passage in the hibernate book, where something similar was done, but I cannot find either, so please give me a little push in the right direction.

Thanks, Peter

[nickarls]

something like

List<Item> items = entityManager.createQuery("from Item i where i.owner = #{identity.username}").getResultList();

(ok, parameter binding is probably more nice)

[pete007]

Thank you, works great! (I added the where-clause to getEjbql() because noone is using the full list)