-----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-----
