Hi,
in timesheet, recent version svn-checkout from trunk, postgres database on linux I get the following error when Ich try to filter my entrys by time, e.g. “Today”:
Invalid SQL: (SELECT ,round(cast(ts_quantityts_unitprice AS numeric),2) AS ts_total,TO_CHAR((TIMESTAMP WITH TIME ZONE ‘epoch’ + (ts_start) * INTERVAL ‘1 sec’),‘YYYY-MM-DD’) AS ts_day,0 AS is_sum_day FROM egw_timesheet WHERE (1377640800 <= ts_start AND ts_start < 1377727200) AND ts_owner=‘12’ AND (ts_status != -1 OR ts_status IS NULL) ORDER BY ts_start DESC)
UNION
(SELECT 0,’’,’’,’’,MIN(ts_start),SUM(ts_duration) AS ts_duration,SUM(ts_quantity) AS ts_quantity,0,NULL,0,0,0,0,0,SUM(round(cast(ts_quantity*ts_unitprice AS numeric),2)) AS ts_total,TO_CHAR((TIMESTAMP WITH TIME ZONE ‘epoch’ + (MIN(ts_start)) * INTERVAL ‘1 sec’),‘YYYY-MM-DD’),1 AS is_sum_day FROM egw_timesheet WHERE (1377640800 <= ts_start AND ts_start < 1377727200) AND ts_owner=‘12’ AND (ts_status != -1 OR ts_status IS NULL) GROUP BY TO_CHAR((TIMESTAMP WITH TIME ZONE ‘epoch’ + (ts_start) * INTERVAL ‘1 sec’),‘YYYY-MM-DD’),0,’’,NULL,ts_total,is_sum_day )
FEHLER: GROUP BY Position 0 ist nicht in der Select-Liste
LINE 3: …h’ + (ts_start) * INTERVAL ‘1 sec’),‘YYYY-MM-DD’),0,’’,NULL,…
^ (-1)
