Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.1.2

Mapping documents:
It's no error and think the problem is clear.


Hello,

within the context of an reporting engine, I need a function, that builds one String from a list of strings returned by property / subselect.

For a example an object "a" has a collection mapped property "string" and a simple property called "name". Then I have to create sth. like:

select o.name, flatten(o.strings) from Object o;

Is there an interface to extends HQL with own functions, if there is no build in possibility I didn't see?

Otherwise I'd think of writing a stored procedure ni PLSQL, but then I have to find out dynamically how this collection is mapped, and what's the key and so on.

Any hints to an approach are welcome.

Thank you.