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 <
[hidden email]> 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.
>
>
Locked
