JIRA Filter

[Chary]

I want to create a filter which results the issues closed in < some X days.

Example:  Issues which are closed within X days....using Created Date and Closing date of issue.

I want like this in filter... (Closing Date - CreatedDate) <= X Days

[zack]

If you have JIRA Service Desk, you could set this up using SLAs that trigger on Issue Created and Issue Resolved. If you would set the SLA to 5 days for example, the SLA would be breached for any days where it look more than 5 days to go from Created to Resolved.

Unfortunately, I don't think there is a way to do this with just JQL.

[Michael Partyka]

Hi Chary,

use this:

status changed to Closed after -7d

It shows all issues which were closed within last 7 days

[Doug Swartz]

If you have scriptrunner available, it has a date compare function. You can do comparisons like: 

issueFunction in dateCompare("project = 'Information Testing'", "resolved < created +15d")

This one returns any issue in the Information Testing project which was resolved within 15 days of being created.

[Aleks Yenin (Polontech)]

Hi,

Try this: https://developer.atlassian.com/display/JIRADEV/Plugin+Tutorial+-+Adding+a+JQL+Function+to+JIRA

[Vasiliy Zverev]

I use script field provided by ScriptRunner plugin to do such things. Here is cade for this one:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.fields.CustomField

import java.sql.Timestamp

return (int) ( issue.getCreated().getTime() - getMillsForCstFd("custom field name 1", issue))/(1000*60*60*24)

public long getMillsForCstFd(String _customFiledname, Issue _issue){
    CustomField customField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName(_customFiledname);
    if(customField == null)
        return 0

    Timestamp cstFldDate = (Timestamp) _issue.getCustomFieldValue(customField);
    return (cstFldDate == null) ? 0 : cstFldDate.getTime();
}