Hibernate version: 2.18

Mapping documents:





I would like to know how to query (in HQL) the user with phonenumber 012-3456789

I would do something like this:
select this from com.example.User this
join this.textData textData
where textData.key = 'phoneNumber' and textData.value = '012-3456789'

But that doesn't work. I can't user 'key' and 'value' as properties of the Map object. Nor can i use 'index' or 'element'. The only option is to use indices and elements, but i don't want to match multiple elements, I want to match a single key value pair. Is this possible in HQL or am I restricted to native SQL?

I'm working on the same thing, if I figure something out I'll reply.

One thought, I've been playing around with joins a bit, and I've been getting some (inefficient) results by joining the map and selecting on the results ...

ie something like ... (I'm pretty sure this won't work)

select user from User
left outer join user.textData
where user.textData.data = ?

I'm confused by the elements in your map though, I think they are strings but hard to tell.

I am trying to avoid the joins though, so I'm working on matching the id's a bit better. My map goes to items that are joined subclasses, so it's a bit confusing.

select this
from com.example.User this
where this.textData['phoneNumber'] = '012-3456789'

Thank you Steve.

Is there a way to do it if you don't know the property name ? That is the hard part for me, since I have a composite type in the map with properties.

Regards,
John.

Any further answer to this?
How to query a simple map element when you don't know (or care) about the index?

Just cross this post....
I guess you could do that

select this
from com.example.User this
join this.textData map
where this.textData[index(map)] = '012-3456789'