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)?

[Yevgen Lasman · Accepted solution]

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.

[Carlo Anapoli]

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

[Yevgen Lasman]

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.

[Nic Brough -Adaptavist- · Accepted solution]

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