Hi all,

I've got a Hibernate entity, called Event, which has a one-to-many metadata entity, EventData.

Given the following Event:

EventId: 1
EventHash: broccoli

With the following EventDatas:

EventDataId: 1
EventId:1
Field: tag
Value: tagme

EventDataId: 2
EventId: 1
Field: tag
Value: anotherTag

How do I create a Criteria query to retrieve the event which has BOTH tags "anotherTag" and "tagme"? In SQL, I'd join the event_data table once for each tag being searched for, but I can only seem to create one alias for the Event.EventData relationship, i.e.



Doesn't work; "duplicate association path: Event.EventData"

Similarly, a normal Conjunction doesn't work, because the clause ends up as:



and, obviously, a database field can't have two different values at the same time.

Any ideas as to how I could clean this up, or is the only option reverting to HQL?

Hi

why u want to go for criteria , IF EventId is mapped with child table EventDatas (one-to-many) you can directly get it using event.getEventDatas() for respective Id.

Regards
Arun

Hi Arun,

The point is I'm *searching* for these Events, using EventData.Content values as the criteria for the search. I basically want to find all EventDatas where field == tag and content == "anotherTag", but without having to do two queries - one to find the eventIds, and another to load the actual Events.