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.
