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

Question

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 ?

Ana-Maria Gologan · Answer

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