From 7c4819527de435c05f72970da07ed35c497e5d76 Mon Sep 17 00:00:00 2001 From: garyhgohoos Date: Mon, 21 Jul 2014 10:36:44 -0400 Subject: [PATCH] Issue #24177:change group by --- .../public/tables/metasql/orderActivityByProject-detail.mql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/foundation-database/public/tables/metasql/orderActivityByProject-detail.mql b/foundation-database/public/tables/metasql/orderActivityByProject-detail.mql index 4d4ce2927..ed6d5f161 100644 --- a/foundation-database/public/tables/metasql/orderActivityByProject-detail.mql +++ b/foundation-database/public/tables/metasql/orderActivityByProject-detail.mql @@ -130,7 +130,7 @@ SELECT prjtask_id AS id, LEFT OUTER JOIN addr ON (cntct_addr_id=addr_id) WHERE (prjtask_prj_id = ) - GROUP BY custinfo.cust_name, prjtask.prjtask_id, addr.addr_city, addr.addr_state, cntct_name + GROUP BY prjtask_prj_id, custinfo.cust_name, prjtask.prjtask_id, addr.addr_city, addr.addr_state, cntct_name, prjtask.prjtask_number, prjtask.prjtask_status, prjtask_username, prjtask.prjtask_owner_username, prjtask_name, prjtask_descrip, prjtask_due_date, prjtask_assigned_date, prjtask_start_date, prjtask_completed_date, prjtask_hours_budget, prjtask_hours_actual, prjtask_exp_budget, prjtask_exp_actual UNION ALL -- 2.39.2