JIRA FIlter Suggestion Required. Urgently

[Aniket_Sapkal]

I am creating this filter:

project = RGSSD AND status not in (Closed) AND updated >= -12h and assignee not in (106397,105391,106369,Manish.Patil,106370,105506,105994,SVenugopal,106528,Rohit.Ghodake,105505,Devendra.Pandey,D.Behera) order BY updated DESC

I want to remove the names listed above, i.e. I want to remove such names of mates of my team who have updated some comments in Jira Ticket.

I want to filter ticket where comment is not updated by team.

[Nic Brough -Adaptavist-]

Your filter translates to

"Open issues in RGSSD updated within the last 12 hours where the assignee is NOT <one of several people>"

I am not clear on what you need to change in there?   What are the conditions for people being included in that list?

[Aniket_Sapkal]

I want to exclude the name of the persons who have added any comment in any ticket.

[Nic Brough -Adaptavist-]

Well, your query is already excluding a load of assignees.

You'd need to find or write a new JQL function for "user has commented on this issue".

The closest I can get without coding is to use a "participants" field from the Jira Toolkit - this will allow you to say "user has never commented and is not the assignee or reporter of the issue"

[Aniket_Sapkal]

I will check and let you know. Thanks!

[Aniket_Sapkal]

I did not found the "participants" field from Jira Toolkit, Please advise.

I need to exclude the users who has commented on particular ticket.

I found "Request participants" not in (105391,106397,Rohit.Ghodake),

I would really appreciate if you can frame the query for me.

Below is the query that I have tried at first place: Now instead of "assignee not in" I need to exclude "user has commented on this issue". Please suggest.

project = RGSSD AND status not in (Closed) AND updated >= -12h and assignee not in (106397,105391,106369,Manish.Patil,106370,105506,105994,SVenugopal,106528,Rohit.Ghodake,105505,Devendra.Pandey,D.Behera) order BY updated DESC

Please revert as soon as you can.

[Nic Brough -Adaptavist-]

Try installing the Jira toolkit, then adding a custom field of type "Participants"

I already said you'll need to write functions to do exactly what you have described, the participants field will get you closest without having to write code.

[Aniket_Sapkal]

How can I install the jira toolkit? Can you please advise?

[Aniket_Sapkal]

I have below version of Jira

License Information for JIRA

JIRA v7.3.2

[Nic Brough -Adaptavist-]

Go to Admin -> Find new add-ons and type "toolkit" into the search.