JQL issueFunction for comments by user in custom field

Hi all!

I need to filter the issues where last comment author is user in custom field (i.e. tempCF).

the issueFunction in commented("by user") is working with the user ID. 

How can I use a custom field here? 

2 answers

(edited)

issueFunction in lastComment("by currentUser()") and assignee = currentUser()

No. The user in CF is not static, for every issue is differ, and I need to create a filter to use it in Automation rules, so CF content must be called for comparison, not particular user

Then you can have a look to : https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html

and look for the JQL functions returning a "user" and see if one matches what you need ? without more details I'd go for currentUser() but it is not necessarily what you're looking for smile

can I do smth like this? 

issueFunction in lastComment("by currentUser()") AND "tempCF"= currentUser()

but there are no results (but I have issues matching the query)

I just tried that with the assignee (system) field and it worked correctly :

issueFunction in lastComment("by currentUser()") and assignee = currentUser()

oh sorry it was my mistake smile

it works, thanks!

0 votes

I think you made that work for the case where you name a particular user, or for the current user, but you can't do what you actually asked for - which is just to find the issues where they are the same.

If you actually need that you could write a new JQL function, but it would not be able to do it using a "pure" lucene query (so slow).

Or you could do a hidden script field which just marks whether they are the same, and query on that (or write a function which is an alias for querying on that).

actually, I dont think that could fast write hidden scripts with such a checking because of being very new in groovy scripting. till this moment it works as I expected (we need to automate email approving process) smile 

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

938 views 5 18
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot