Reports ignore UNBILLABLE tickets
|Reported by:||roterl@…||Owned by:||bobbysmith007|
Created tickets that doesn't mark as billable aren't shown in the reports.
eg. Clicking the "Ticket Hours" it only display the tickets that marked as billable. The "Ticket Hours" link is: .../report/12?BILLABLE=1&UNBILLABLE=1&ASSIGNED=assigned&ACCEPTED=accepted&CLOSED=closed&NEW=new&REOPENED=reopened&STARTDATE=0&ENDDATE=2000000000 It seems that UNBILLABLE should be displayed.
To fix it I changed the queries from
AND billable.value in ($BILLABLE, $UNBILLABLE)
AND billable.value in (CASE WHEN $BILLABLE = '1' THEN '1' else END, CASE WHEN $UNBILLABLE = '1' THEN '0' else END)