Hi all!

I have the following problem: There is a domain model class and some properties of it are mapped to the columns in a database table. This class has some business properties (BP), which are not persistent, but can be calculated upon a request from the persistent properties (PP), e.g. let's say that property BP1 = PP1 - PP2 - PP3.

I need to create a HQL query such that the result would be ordered by a business property. But I can't just write "...order by <ClassName>.BP1" as the property BP1 is not mapped to any database column...

What I think about is to create a CompositeUserType for the property BP1, which is mapped to the columns corresponding to PP1, PP2 and PP3. Will I be able to perform ordering in this case? May the same column from a database table be mapped with a build-in type to some class property (e.g. to PP1) and be mapped with a composite type as a part of another property (e.g. of BP1) at the same time?

Many thanks.

You can define a property with a formula:

You can define a property with a formula:

You can define a property with a formula:

You can define a property with a formula: