I want to find all the open issues that my team (6 users) want update in the last 24 hours.
How can I do it with JQL ?
Hi,
You can achieve that with JQL by using JJUPIN plugin. For that you 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 you created the file, you can use in search like below:
key in silJQLList("notUpdatedByUsersInGroup.sil", TEST, jira-developers)
Where "notUpdatedByUsersInGroup.sil" is the name of the SIL script, TEST is the name of the project and jira-developers is the name of the group.
You can find more JQL searches here: https://confluence.cprime.io/display/TR/SIL+JQL+Se arch
Also, you can read more about SIL Routines here:
https://confluence.cprime.io/display/SIL/Routines
Best Regards,
Ana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.