I have created new worklog attribute. Is there a mean to filter my worklogs on that attribute ?
In my case I have created an attribbute called InvoiceNr that holds the invoice number to which a worklog is attributed (we mostly fill this field afterwards in Report view, when we bill the client). It would be very handy to be able to filter on a given InvoiceNr to find all related logs. Also it would enable to quickly find which hours have not yet been invoiced.
I could also live with only the possibility to order the table according to an attribute, but alas the attribute columns are not enabled for ordering (why ?).
I just spent a day billing hundreds of worklogs. Once I had filtered the woklogs using component or version filtering, I wish I had a "bulk edit attribute" option like in JIRA issue navigator, to set all my "InvoiceNr" fields at once to a value, and not log per log.
If Tempo adds JQL filtering on any attribute, adding a "bulk edit" feature woul be very powerful. For example I could filter out all worklogs already billed (selecting only those with "InvoiceNr is Empty") and set all these unbilled worklogs a new InvoiceNr.
If anyone intersted in a filtering on worklog attributes please vote for this feature request https://tempoplugin.jira.com/browse/TT-12
I think both filtering and grouping are useful. Filtering is good if you want to generate a report specific to an attribute value. E.g we we have a field called "Invoice nr". If we could filter on invoice number we could directly generate an "invoice detail" report to join to the invoice. For our company this is the most wanted feature. (having to export to Excel is a costly overhead).
Also we could filter the report view on "Invoice nr. IS empty" to see what still need to be invoiced. We could then pick some worklogs and fill the "invoice nr." and subsequently generate a filtered report on this invoice nr. to have the invoice total.
With a filtering feature you will be able to advertise Tempo as a basic invoicing system which is a great added value (I would be much pleased if Tempo adopts this idea on its own and creates an official "Invoice Nr" field to the worklog attributes).
Note: the filter should accept JQL expressions (not only filtering on a single field).
Use case: some worklogs are "not billable". So I want to be able to filter these worklog out when I filter on a "Invoice Nr. Is Empty". The JQL would be something like "Invoice Nr Is Empty AND NotBillable = False"
I am looking for grouping worklogs by attribute value. Let's say I have an attribute "Type" and the values are Work,Commute,Meeting. I would want to filter all worklog entries which type is Meeting. If the worklog attribute is a numeric input field, I would also want to see totals counted at the bottom of the report page.