Hi huang
try to create a view-entity with complexe alias amount on amount1 and
amount2.
Nicolas
Le 14/02/2012 11:01, hzz6222003 a ??crit :
Hi, every one
the entity modle as follows:
<entity entity-name="Pay" package-name="com.iit.yinshang.order" title="Yingshang
payment YLCard pay">
<field name="orderId" type="id-ne" />
<field name="amount1" type="currency-amount" />
<field name="amount2" type="currency-amount" />
<prim-key field="orderId" />
</entity>
how can l get the rocorders by the following sql:
select * from pay order by amount1+amount2 desc
Kind Regards
huang zhong zhou
--
Nicolas MALIN
Consultant
T??l : 06.17.66.40.06
Site projet : http://www.neogia.org/
-------
Soci??t?? LibrenBerry
T??l : 02.48.02.56.12
Site : http://www.librenberry.net/
