{11} Developer Work Summary

Reports Must Be Accessed From the Management Screen

Report execution failed:
DataError: invalid input syntax for integer: ""
LINE 18:       AND ticket_change.time >= ''
                                         ^

SELECT COUNT(*) FROM (

SELECT author as __group__,__style__, ticket, summary,
  newvalue as Work_added, time as datetime, _ord
FROM(
  SELECT '' as __style__, author, t.id  as ticket,
    t.summary as summary,
    CASE WHEN newvalue = '' OR newvalue IS NULL THEN 0
         ELSE CAST( newvalue AS DECIMAL ) END as newvalue,
    ticket_change.time as time, 0 as _ord
  FROM ticket_change
  JOIN ticket t on t.id = ticket_change.ticket
  LEFT JOIN ticket_custom as billable on billable.ticket = t.id
    and billable.name = 'billable'
  WHERE field = 'hours' and
    t.status IN (%s, %s, %s, %s, %s)
      AND billable.value in (%s, %s)
      AND ticket_change.time >= %s
      AND ticket_change.time < %s

  UNION

  SELECT 'background-color:#DFE;' as __style__, author, 0 as ticket,
    Null as summary,
    SUM( CASE WHEN newvalue = '' OR newvalue IS NULL THEN 0
         ELSE CAST( newvalue AS DECIMAL ) END) as newvalue,
    NULL as time, 1 as _ord
  FROM ticket_change
  JOIN ticket t on t.id = ticket_change.ticket
  LEFT JOIN ticket_custom as billable on billable.ticket = t.id
    and billable.name = 'billable'
  WHERE field = 'hours' and
    t.status IN (%s, %s, %s, %s, %s)
      AND billable.value in (%s, %s)
      AND ticket_change.time >= %s
      AND ticket_change.time < %s
  GROUP By author
)  as tbl
ORDER BY author,  _ord ASC, time

    
) AS tab
Note: See TracReports for help on using and creating reports.