Page Comparison

On this page:

...

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

Find issues with subtasks

In order to achieve thatTo find all issues with subtasks, we need to write this simple JQL:

key in silJQLExpression('size(subtasks(key)) != 0', 'project = TEST')

To perform a more advanced search like searching for closed issues with open subtasks , we need to create a SIL script:

string [] keys = selectIssues("project= " + argv[0] + " and resolution= "+ argv[1]);
string [] ret;
for(string k in keys) {
    string [] subtasksKeys = subtasks(k);
    if(size(subtasksKeys) != 0) { 
        for(string sk in subtasksKeys) {
            if(%sk%.status == argv[2]) {
                ret += k; 
            }
        }
    }
}

return ret;

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

key in silJQLList("parentsOf.sil", TEST, Done, 'To Do')

Find subtasks of issues

To search for the subtasks of issues we need to create a SIL script:

...

key in silJQLList("subtasksOf.sil", TEST, Done, 'To Do')

Find 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')