Reports ignore UNBILLABLE tickets

[roterl@…]

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)

[Russ Tyndall]

Are you sure you checked both the billable and unbillable checkboxes on the page that lists the reports? It has been working for me for quite a while, so it is a bit odd that you are having issues. Typically, when you have billable checked and unbillable checked it results in /report/12?BILLABLE=1&UNBILLABLE=0... and when you have billable checked and unbillable unchecked results in a link to /report/12?BILLABLE=1&UNBILLABLE=1....

If you are sure you are actually having issues, are you receiving any javascript errors? What browser are you using? Thanks for the info.

HTH, Russ

[anonymous]

I find out that the billable and the unbillable have inversed check status (when check one set to 1 and the other set to 0) This lead to me to think that the 0 has wrong results. Sorry for that.

Any way, I think it better to keep convenience of set is "1" and unset is "0".

thanks Rotem.

[Russ Tyndall]

You are certainly welcome to continue using your changes, however, I do not think that I will include them into the main version of the plugin, as there is not really a benefit to implementing them.

Thanks for the feedback, Russ