How can I find ticket that wasnt update or comment by specific 6 users ?

irinr April 5, 2017

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 ?

 

 

1 answer

0 votes
Ana-Maria Gologan April 6, 2017

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

Suggest an answer

Log in or Sign up to answer