I am trying to assemble a query using hibernate criteria.
In my db, there is a [Game]
table, a [Tag]
table, and a many-to-many relationship modelled using a join table called [GameTag]
, which contains a game_id
field and a tag_id
field.
My input is a list of tags (or tag_ids), and I would like to retrieve all games having all of these tags.
[example]
game 1 has tag1, tag2 and tag3
game 2 has tag2 and tag3
game 3 has tag3
My input is [tag2, tag3].
My output should be game 1 and game 2, as these both have the two tags specified.