Hello,


class Menu {
@OneToMany
List<Item> items;
}


class Item {
@ManyToOne
Menu menu;

@ManyToMany
List<Role> roles;
}



For the above, how can I select all the Menu(s) which has item(s) and the roles of the item(s) must be in the one of the roles that the user pass into ?


For a psechudo SQL, "select menu from item where item.roles in :roles" ???




Best regards,
Eric

the query you've used with aliases, that's all.