Typically, data queries are put in services (so they can be reused) and
then the service is called by the form's actions element.
-Adrian
su2 wrote:
Hello Friends,
I have a form - myForm.xml
I want to create following field in myForm.xml
<field name="subTotal" title="${uiLabelMap.mySubTotal}">
<display
description="${bsh:org.ofbiz.my.my.MyHelper.getSubTotal(myOrderNo)}"/>
</field>
For this I want to create java class - getSubTotal()
Where I want to pass current orderno and get subtotal(=itemsubtotal +
shipping charges)
for that I want to create a SQL query in my java class - getSubTotal()
SELECT (itemsubtotal+shippingCharges) as subTotal FROM myTable where orderNo
= $(mypassedOrderNo);
Is this possible to do in java class?
If yes, can somebody guide me?
Thank you for the help in advance.
Su-
