id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 4686,Reports ignore UNBILLABLE tickets,roterl@…,Russ Tyndall,"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)'' into ''AND billable.value in (CASE WHEN $BILLABLE = '1' THEN '1' else '' END, CASE WHEN $UNBILLABLE = '1' THEN '0' else '' END)'' ",defect,closed,normal,TimingAndEstimationPlugin,normal,invalid,,,0.11