Page Comparison

On this page you cand find searches for:

...

If we want to find the issues where work had been logged by a specified user. We can do this by using silJQLExpression:

...

Also, we can use this JQL to find the issues where work had been logged on a given date:

key in silJQLExpression('size(getWorklogIds("2017-03-16", key)) != 0', 'project = TEST')

...

key in silJQLExpression('size(linkedIssues(key, "Relates")) != 0', 'project = TEST')

To find all the issues that are blocked by issues with status "To Do" we could use:

key in silJQLExpression('size(linkedIssues(key, "Blocks", 1)) != 0', 'project = TEST')  and status = 'To Do'

If we want to search for the linked issues whatever the link type with resolution "Done" :

key in silJQLExpression('size(linkedIssues(key)) != 0', 'project = TEST') and resolution = Done

...

Issues by comparing dates

To search for issues that were resolved after the due date:

key in silJQLExpression('resolution > dueDate', 'project = TEST') 

To find issues that were updated within one week after being created:

key in silJQLExpression('updated < created + "1w" ' , 'project = TEST')

Issues that had changed priority

For example, if we want to search for issues that had the priority "Medium" and now has the priority set to "High". We can perform the following search:

key in silJQLExpression('arrayElementExists( fieldHistory(key, "priority"),  3) ', 'project = TEST') and priority = High //where 3 is the priority id for "Medium"

Issues which have not been updated by the users from a specific group

In order to find issues that have not been updated by the users form a specific group in the last 24 hours,  we need to create a SIL script:

string [] keys = selectIssues("project = " + argv[0]);
string [] ret;
for(string k in keys) {
    boolean updatedByUsersInGroup = false;
    JFieldChange [] changes = lastIssueChanges(k);
    for(number i = 0; i < size(changes); i++) {
        if(userInGroup(argv[1], changes[i].user) && (currentDate() - changes[i].#{date} < "24h")) {
            updatedByUsersInGroup = true;
        }
    }
    if(!updatedByUsersInGroup) {
        ret += k;
    }
}
return ret;

After we created the file, we can use the script in search like below:

key in silJQLList("notUpdatedByUsersInGroup.sil", TEST, jira-developers)