Hi,
I have 2 entities...
Audio Tag
These are setup as a many-to-many, Audio has a reference to Tags, but Tags doesn't have a reference back to Audio.
What i want to do is return all tags matching a search query with a count of how many Audios for each tag, they also need to be ordered by the Tags with the most Audio items.
Just to make it a little more complicated, it also needs to be paged.
I would prefer to use the Criteria API if possible.
Hope somebody can help because i have searched for days but can't find a solution.
Paul