Index: openacs-4/packages/ecommerce/www/admin/orders/index.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/index.xql,v diff -u -r1.4 -r1.4.8.1 --- openacs-4/packages/ecommerce/www/admin/orders/index.xql 13 Sep 2002 00:42:09 -0000 1.4 +++ openacs-4/packages/ecommerce/www/admin/orders/index.xql 9 Feb 2005 10:06:32 -0000 1.4.8.1 @@ -10,6 +10,15 @@ + + + select + sum(one_if_within_n_days(in_basket_date,1)) as s_b_in_last_24_hours, + sum(one_if_within_n_days(in_basket_date,7)) as s_b_in_last_7_days + from ec_orders + + + select