CriteriaQuery entity.list has value

Asked Jul 24 '18 at 08:32

Active Jul 24 '18 at 08:40

Viewed 16 times

I have an entity that has a list of enitities connected to it. Customer.roles = List<Role>()

Now I get roleId as input and I'd like to know if customer has the role connected to it.

I've tried several Ways using CriteriaQuery but haven't yet found the right way. How to do this using CriteriaQuery.

Idealy I'd like something like: fromCustomer.get("roles").has(roleId)

asked Jul 24 '18 at 08:32

Mihkel L.

can you give me a table description of both tables *Customer* and *Role* – Navin Gelot Jul 24 '18 at 08:40
`Customer` table has just the usual fields: id, firstname, lastname etc. Role table has `id, customer_id, role_type_id, valid_from, valid_to` – Mihkel L. Jul 24 '18 at 09:15

0 Answers0