Hi

I have defined the following query but it does not parse:

select
sum(lifeAssured.benefits.sumInsured)
from
LifeAssured lifeAssured
where
lifeAssured.client.clientNumber = '12345678';

LifeAssured.benefits is a bag of type Benefit, Benefit has a property sumInsured of type BigDecimal. I have tried various combinations of the select clause including

select sum(elements(lifeAssured.benefits).sumInsured)

and

select sum(elements(lifeAssured.benefits.sumInsured))

but none of these parse -- can anyone help out with the syntax here? Do I need to make an inner join?

Thanks

Niall

Any hints?