nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filters for Automation rules

Ankit Nangia

Can we add filter to the automation rules? Through automation rules i am creating automated tickets which are sent on daily basis to assignee. Now i want to use a filter determining on each day which assignee is working for how many hours and on what tickets.

For example i need to see on monday , assignee =xyz has worked for how many hrs on on what all tickets. Please let me know if there is any filter JQL query .

Accepted answers

Krister Broman _Advania_

Yes, you can use filter in JQL query and use them in automation rules - i.e. filter = FILTERABC

BUT

No you cannot use a filter to calculate a sum total, the filter is a dynamic list of matching issues and has no built in calculation. Some plugins allow for doing calculations in a filter, but I do not think that you can use those results in automation as they generally present their result in a gadget. Other plugins calculate fields but would not calculate based on a filter.

If you are going to do this it probably involves a lot of custom scripting to get right.

All comments

Krister Broman _Advania_

Yes, you can use filter in JQL query and use them in automation rules - i.e. filter = FILTERABC

BUT

If you are going to do this it probably involves a lot of custom scripting to get right.

Ankit Nangia

@Krister Broman _Advania_ Can you provide some more detail as in how i can use filter in JQL query and use them in automation rules?...what steps need to be follow to have a filter according to day.

For eg I need to know on Monday who all have worked and on which tickets.

Krister Broman _Advania_

Again finding out which persons work on day X would be a summation or rather a grouping of persons and that is not what Filters are for.

The filter will easily find the issues that was done on that day by using the StartOfWeek Function i.e.

Find issues updated on tuesday: updated >= startOfWeek(1d) AND updated <= startOfWeek(2d)

If you create this in FilterABC then this can be reference through the JQL function filter = FilterABC

StartofWeek is a specific time, so for the update field which is date/time you have to have a start and stop while for a pure date field (like due date) you can make due with just a start date.

But if Person A has worked with 5 issues, you are going to get 5 results for the filter.

Thomas Magny-Garcia

Hi @Krister Broman _Advania_ ,

I think it is possible to made some calculation in JQL query using issueFunction method, don't you?

For example, to see the total estimate for all issues in the LOAD project run this jql:

project = LOAD and issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()")

However, I don't think you can use the work log (I assume @Ankit Nangia want to use it to get the time spent by xyz on the subjects ) with this way...

Hope it helps !