You can use the Java event or a BSH to trigger the query against the database. The result can be then passed on to the 'Form' .
Anyways, is your query giving you the correct result? As I find you are using a String data-type for storing a date value. May be it is, but it will not always give u what u r seeking. Regard, Gautam Deb On 8/10/07, nashrul <[EMAIL PROTECTED]> wrote: > > > Hi all, > I am a newbie ofbiz user. There is something I would like to ask. Here is > the case. > I have a Report table in oracle 10g. In this table, i have report_period > field which is string type. It contains the report period date. > In the ofbiz form, I want to display the maximum date of this field. So i > have to query the database.. : select max(reportPeriod) from Report and > show > the result. How can I do this ?? Since I cannot find a way to do this in > the > form widget .. > Thanks > -- > View this message in context: > http://www.nabble.com/Problem-displaying-query-in-the-form-tf4247491.html#a12087765 > Sent from the OFBiz - User mailing list archive at Nabble.com. > >
