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:
| Code Block |
|---|
|
key in silJQLExpression('size(getWorklogIds("2017-03-16", key)) != 0', 'project = TEST') |
...
Find issues with subtasks
In order to achieve that, we need to write this simple JQL:
| Code Block |
|---|
|
key in silJQLExpression('size(subtasks(key)) != 0', 'project = TEST') |
Find subtasks of issues
To search for the subtasks of issues we need to create a SIL script:
| Code Block |
|---|
|
string [] keys = selectIssues("project= " + argv[0]);
string [] ret;
for(string k in keys) {
string [] subtasksKeys = subtasks(k);
if(size(subtasksKeys) != 0) {
for(string sk in subtasksKeys) {
ret += sk;
}
}
}
return ret; |
After we saved the file, we can perform the search using a silJQLList like this:
| Code Block |
|---|
|
key in silJQLList("subtasksOf.sil", TEST) |
If we want to perform a more advanced search like searching for the subtasks with status "TO DO" of issues with resolution "Done", we could use this script:
| Code Block |
|---|
|
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 += sk;
}
}
}
}
return ret; |
| Code Block |
|---|
|
key in silJQLList("subtasksOf.sil", TEST, Done, 'To Do') |