Hi,

ParentMessage and Message are the tables.

I have a collection field called "messages "in the "ParentMessage" entity class. Now i want to get the name of the message which is having the maximum amount for each ParentMessage?

Here name and amount are the columns in the Message table.

I have declared one-to-many and many-to-one mappings in both the mapping files.

Is there any way to get the maximum amount using the formula attribute or any other ways?

Please kindly help me.

Thank you.