GenericDelegator How To - SELECT MAX(CAST (hospital_id AS int4)) FROM hospital

[kVoid]

Hi,

Does anyone know how can I write an equivalent of this SQL Statement (postgres):
SELECT MAX(CAST (hospital_id AS int4)) FROM hospital;
using GenericDelegator java class of ofbiz?

Thanks,
Valentin

[BJ Freeman]

Look at the webtools code that pass sql.
https://demo.ofbiz.org/webtools/control/EntitySQLProcessor

kVoid sent the following on 4/16/2009 7:47 AM:
> Hi,
>
> Does anyone know how can I write an equivalent of this SQL Statement
> (postgres):
> SELECT MAX(CAST (hospital_id AS int4)) FROM hospital;
> using GenericDelegator java class of ofbiz?
>
> Thanks,
> Valentin