ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From BJ Freeman <bjf...@free-man.net>
Subject Re: View-Entities Group by month
Date Wed, 04 Mar 2009 11:17:45 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

the view-entity is basically for grouping entities
then you use a findlist to get the data you want.

madppiper sent the following on 3/4/2009 2:39 AM:
> Hey everyone,
> 
> If I was to create the following statement:
> 
> SELECT ORDER_HEADER.*,MONTH(created_stamp) as month, count(order_id) as
> ordersum FROM ORDER_HEADER GROUP BY Year(ORDER_HEADER.CREATED_STAMP),
> Month(ORDER_HEADER.CREATED_STAMP)
> 
> Which is basically a simple View on the Order Header data where I group all
> orders by the month they occured in and the number of orders, how could I
> create the same within a view-entity where the month() command is not
> available? 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJrmNZrP3NbaWWqE4RAliUAJ9NtEm3imCmpMwgtJjPqOhKUmkhVwCfeu9m
rOdxGvqPsEIyapbbHRf3tVc=
=yQhF
-----END PGP SIGNATURE-----

Mime
View raw message