nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Search for issues with comments by user and text

luca-pittino

I'm searching for all Jira issues with comments written by a given user and containing some given text.

I'm already aware of how I can search for issues with comments by a given user, for example:

issueFunction in commented("by user@domain.com")

or, if looking for my comments,

issueFunction in commented("by currentUser()")

But I'd like to specifically filter by comments satisfying both conditions: author and content. How can I achieve this?

Queries like

issueFunction in commented("by user@domain.com") and comment ~ 'text'

of course don't satisfy my requirement.

Thanks in advance!

Accepted answers

All comments

Björn Schotte

Hi Luca,

I do have similar problems. Did you solve the issue?

luca-pittino

Not with a query unfortunately, nor with Jira filters.
I guess a search with similar expressiveness is unsupported at the moment.

In my case I searched by text, as I got the fewest results, and then manually checked the text occurrences and saw who the comment author was.

Ashkan Malekly_4jfgcl

Hi @luca-pittino and @Björn_Schotte

I had tried this jql and get my favorite result

Comment ~ "\"text\"" and issuefunction in commented (" by user@domain.com")

luca-pittino

Hi @Ashkan Malekly, I guess your case was a lucky combination

Your suggestion is basically the last query I wrote in my question above, with the difference you're searching `"text"` (quotes included).

My problem is that I need to match isses having single comments satisfying both conditions A and B, but I can only get issues with some comment satisfying A and some other comment satisfying B.

Ashkan Malekly_4jfgcl

Hii @luca-pittino

No in my code include ( \ ) this is important.

this is yours: comment ~ 'text'

And this is mine : comment ~ "\"text\""

luca-pittino

Sorry @Ashkan Malekly, I think I've been mislead by the fact that even using quotes I still got many results with comments not matching both conditions (false positives)..

Actually though, the amount of results with and without quotes is different (e.g. ~70 and ~120 respectively).

Maybe something related to Jira app version? I'm using Jira Server 7.1.4, maybe on later versions they did some improvements?

Nicolas PR

Hi,
it's complicate to manage some special chars for your condition 'comment ~' (escape with '\' or '\\' )

you have to escape the special chars ex: https://confluence.atlassian.com/jirasoftwareserver/search-syntax-for-text-fields-939938747.html#Searchsyntaxfortextfields-escapingSpecialcharacters

Vasiliou, George

This is exactly what I am looking for, but we're on the cloud version now and get an error.

The URL provided at the end gives a 401 error also; there is no help there either.

The "commented" JQL function provided by "Adaptavist Scriptrunner" for Jira Server works differently in Jira Cloud. Run it directly in "Enhanced Search" instead. See the documentation for more details: https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-jql-keywords-functions

luca-pittino

I guess the expected doc page is https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-keywords.

But again I don't see a solution for the matter...

Jasmin Bateman

In answer to both your queries:

We have a documentation page linked here dedicated to highlighting the differences in JQL syntax between ScriptRunner for Jira Server and ScriptRunner for Jira Cloud.

For your search query, if you are trying to use the server syntax:

issueFunction in commented("by <insert user>")

then please replace this with the equivalent cloud syntax:

commentedBy = <insert user account ID>

To achieve the same output in ScriptRunner ES for Jira Cloud.

Please let me know if this solves your query issue.

Kind regards,

Jasmin

Vasiliou, George

I actually figured this out and tried it, but I got zero results. The Example they provided on the page is

commentedBy = 5f8eddaaf162650070bce0fb

No issues were found to match your search

If I use something similar:

Text ~5f8eddaaf162650070bce0fb

I get a ton of results. Some of the results are from comments I made, and some are with comments others made and tagged me. Either way, I do get results that prove the formula above is NOT working, oddly. I would like to only filter by the comments I made and exclude the comments where I am tagged. I am still looking for a correct way to do this because the temporary solution I came up with has too many comments I have to view that are not what I need and just become noise.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql

atl-gruland