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; } } }

How can I research a comment and see it?

Carlo Anapoli

Hello everybody,

I have many comments in several issues and I would like to filter them. For example I can found all the issue where a comment includes a particular word using: comment ~ word but I can found only the issue (with all the comments).

Is there a way to filter and see that particular comment (which includes the word)?

Accepted answers

Nic Brough -Adaptavist-

No, searching finds issues, not the individual parts of issues you've searched for.

Yevgen Lasman_v96izq

If you have access to the database (either from backend or using one of the plugins available on the Marketplace), you can use the next SQL to find comments you need:

select * from jiraaction where actiontype = 'comment' and actionbody like '%<WHAT YOU NEED GOES HERE>%';

make sure to leave "%" around the text you're looking for. This example would work with virtually any database supported by Jira, but if you know the specific database engine you can make more sophisticated query eg. using regular expressions, etc.

All comments

Nic Brough -Adaptavist-

No, searching finds issues, not the individual parts of issues you've searched for.

Carlo Anapoli

Thank you Nic,

Thus, the only way to find the specific comment inside an issue is to export the issue as XML or Word and do a research there, is it right? No way

Yevgen Lasman_v96izq

If you have access to the database (either from backend or using one of the plugins available on the Marketplace), you can use the next SQL to find comments you need:

select * from jiraaction where actiontype = 'comment' and actionbody like '%<WHAT YOU NEED GOES HERE>%';

Carlo Anapoli

Thank you Yevgen, I'll talk with my IT manager and we'll try

Yevgen Lasman_v96izq

And if there are any data integrity concerns, you can request the read-only credentials so you may not accidentally delete or modify anything, just read.

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

comment

jira-server