Hi
Thank you for reading my post
I have a view Object which I add two Business components to it
-Bankpayment
-AccountType
In the query that i write to select some of required field i add all fields from those two compoents.
here is the sql statement:
SELECT Bankpayment.id,
Bankpayment.amount,
Bankpayment.sourceBankCode,
Bankpayment.invoiceCode,
Bankpayment.invoiceDate,
Bankpayment.startDate,
Bankpayment.endData,
Bankpayment.serviceType,
Bankpayment.additionDate,
case Bankpayment.approved
when 1 then 'Yes'
when 0 then 'No'
end as approved2,
case Bankpayment.defered
when 1 then 'Yes'
when 0 then 'No'
end as defered2,
case Bankpayment.status
when '0' then 'Pending'
when '1' then 'Approved'
when '2' then 'Rejected'
end as status2,
Bankpayment.approveDate,
Bankpayment.deferDate,
Bankpayment.defer_reason,
Bankpayment.user_ID,
AccountType.account_type,
AccountType.Account_description
FROM BANKPAYMENT Bankpayment,AccountType AccountType
WHERE user_ID=? and Bankpayment.serviceType=AccountType.id
something is odd that Account_type is not shown under attributes node and also i should say that all fields of the second component are marked as Transient , also some of the first table columns are marked Transient .
can some one tell me wht does it means ?
the other odd thing is that, when i execute the above query in Mysql manager, it shows the correct result for all columns but when i use it in an ADF table (binding) it does not shows second table column's values.
is it related to that Transient stuff?
The other thing is that, i used Database physical fields name for my query, is it ok?
here is an image which show the View object with cmplete details
http://i14.tinypic.com/48eec6v.jpg
Thanks
Thanks