I am using an interface that is implemented in two classes:
<class-descriptor class="appian.tracking.beans.Actor">
<extent-class class-ref="appian.tracking.beans.Team" />
<extent-class class-ref="appian.tracking.beans.Person" />
</class-descriptor>
This bean "Actor" is joined to another table "Task" (an "Actor" bean is an attribute
of the "Task" bean.)
Next I would like to use the ReportQueryByCriteria Class for getting a select on the
"Task". I need the report for sorting and other properties associated with the
ReportQuery.
One of the columns I set is mActor.mName which should do an outer join and find either
a Person or a Team. Then I would like it to pull the property "Name" from whichever
Table is relevant.
The sql generated by OJB is below:
SELECT A0.ID, A1.NAME, A0.TEMPLATE, A0.DESCR
FROM TRK_TASK A0, TRK_TEAM A1,TRK_PERSON A1E1,
WHERE A0.TO_GRP=A1.ID(+) AND A0.TO_GRP=A1E1.ID(+) AND (A0.CASE = '1041' )
as you can see the outer joins are performed properly, resulting in all relevant rows
in the task table being returned. My problem is the Value for NAME only comes from
the team table. Therefore when the join is for a person the value is blank.
I was wondering If anyone knows "is OJB is even supposed to support this behavior?"
and if so or not, "how would I go about solving this problem/creating a work-around?"
Thanks in advance.
-phil
_________________________________________
Phil Armour
Appian Corporation
www.appiancorp.com
Phone: 703.893.4124 x177
Fax: 703.442.8919
Mobile: 202.294.4587
Email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
