computed property question

brandon_booth · **Joined:** Wed Dec 03, 2003 5:23 pm **Posts:** 7

If I use the formula attribute of property how do I refer to other properies in the sql statement?

emmanuel · **Posted:** Wed Dec 03, 2003 7:48 pm

I don't think you can right now.
Submit a request to Jira (if there isn't any on this subject)

brandon_booth · **Joined:** Wed Dec 03, 2003 5:23 pm **Posts:** 7

I tried this:

<id name="id" column="id" type="long">
<generator class="sequence">
<param name="sequence">security_seq</param>
</generator>
</id>

<property name="name" column="NAME" type="string" />
<property name="description" column="DESCR" type="string" />
<property name="path" column="PATH" type="string" />

<property name="childCount" insert="false" update="false"
formula="(select count(*) from user_group_hierarchies ugh where ugh.parent_group_id = id)"
/>

where the id primary key is refered to at the end of the select statement, which seems to be working. I guess I was expecting to have to delimit the property somehow.

emmanuel · **Posted:** Wed Dec 03, 2003 8:46 pm

I read in the HQL statement and not in the sql statement => wrong answer.

gavin · **Posted:** Wed Dec 03, 2003 9:03 pm

The formula attributes refers to columns, not properties.

brandon_booth · **Joined:** Wed Dec 03, 2003 5:23 pm **Posts:** 7

I think I'm beginning to understand. thanks.