Hi all,

I'm using something very simmilar to this one: http://www.xylax.net/hibernate/entitymap.html . In other words I have a map assigning users a kind of boolean flag:


The problem is when I try to query Tasks (Task has a property with key-value collection - User->SendInfo) to get tasks of which user should be notified (exists in Task's Person collection as a Key and has Value (SendInfo) = TRUE). Currently I have a HQL query:

That gives me collection which I have to iterate to get only that tasks, where the given user exists with SendInfo=TRUE. I wonder if it is a way to avoid this iteration. Could anyone help me to modify my query to achieve that?

--
michal

Maybe adding "and t.Persons[user] = true" will do it? Or maybe "and indices(t.Persons) = true"?

Thank you for quick reply, but I'm still having trouble.

"and t.Persons[:user] = true" -> Index was outside the bounds of the array.
"and indices(t.Persons) = true" -> database server says that the query syntax is invalid (incorrect syntax near....)

tried also :
"and elements(t.Persons)=true" -> Invalid column name 'true'
"and elements(t.Persons)=1" -> subquery returned more than 1 result ....

That brings me an idea to use subquery but I'm still mixed. I think about something like:

Of course this is wrong, I have no idea what to put instead of "select * from t.Persons where Value=true" .

In the docs there are examples of HQL queries with subqueries but only for "set" and "list" collections. I can't find any example with "map".

Any futher suggesions?

--
michal