Notifications and Queries based on Number of Tickets

[Brian Clampet]

Is it possible to receive notifications if either of these two queries are true:

1) a user has more than 10 overdue tickets

2) a user has more than 50 assigned tickets

I am cannot figure out how to compose the filter needed for either of these queries or how I would receive notifications if these filters would be met. Is this possible?

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

I don't think there is a way to retrieve notifications based on issue count in the filter (except 0!). You can do customizations in downloaded versions but not in onDemand.

If it is mission critical, you can write a third party service that pulls data from the filter via REST API calls and check the count before sending out an email!

[Brian Clampet]

Thank you both for the feedback. Jobin Kuruvilla, I will be migrating to the self hosted version in the next 6 months. What are these customizations you write about?

[Jobin Kuruvilla [Adaptavist]]

Maybe write a JIRA service that periodically checks the filter(s) and send email once the number of issues in it reaches a configured number?

[Brian Clampet]

Is this possible to do with JOD? or must I wait until I am self hosting?

[Andrew Wolpers [BlackPearl PDM]]

What's your criteria for "Overdue"? If you have a due date, you can create a filter based off of issues created X days before, which can be the criteria to create a subscription to send email updates.

In the same fashion, you can create a filter and subscribe to it for the latter question.

Let me know if this helps: https://confluence.atlassian.com/display/JIRA/Receiving+Search+Results+via+Email