ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From madppiper <p...@mutschler.ch>
Subject View-Entities Group by month
Date Wed, 04 Mar 2009 10:39:37 GMT

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? 
-- 
View this message in context: http://www.nabble.com/View-Entities-Group-by-month-tp22327481p22327481.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


Mime
View raw message