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 in comments using wildcard?

Sandra Meessen

Hello, I want to search in comments in 1 specific project and expect to use wildcards, but "?" and "*" don't do the tric for me. Please help? The string I want to search on is "v2017_50_2_BO_UG". Values I expect are e.g. "v2017_50_2_BO_UG_1" or "v2017_50_2_BO_UG_1test1" or "v2017_50_2_BO_UG_3test2". Thanks!

Accepted answers

All comments

Andy Heinzer

Hi Sandra,

Jira has a limitation in regards to what it can search. In this case, it is known as whole word searches. However in your case, I think that you can use the fuzzy searches referenced in that document in order to find these issues.

If you're using Jira's basic search try to just enter a search of

v2017_50_2_BO_UG~

If you're using the advanced mode for searching, try the JQL search of:

comment ~ "v2017_50_2_BO_UG~"

These search methods should be able to help you find this information in Jira. Please let me know if this helps.

Andy

Sandra Meessen

Hello Andrew, thank you for your hints. Unfortunately the fuzzy searchs gives way more results than wanted, because it does not only search for everyting starting with "v2017_50_2_BO_UG", but also gives everything looking like that, e.g. "v2017_50_2......"

e.g. I have 2 strings which can appear in comments "v2017_50_2_BO_UG_7" (9 appearances) and "v2017_50_2_BO_UG_7test1" (12 appearances).

When I advance search with "comment ~ "v2017_50_2_BO_UG_7" the results are the 9 appearances, without the 12 appearances 7test1.
When I advance search with "comment ~ "v2017_50_2_BO_UG_7?" the result is a message saying "No issues were fount to match your search"
When I advance search with "comment ~ "v2017_50_2_BO_UG_7*" the result is a message saying "No issues were fount to match your search"
When I advance search with "comment ~ "v2017_50_2_BO_UG_7~" the results are 569 appearances of everyting looking like "v2017_50_2_BO_UG_7", variying from "v2017_50......." to "v207_50_2_BO_UG_7".

So none of these give me the answer I am looking for (12 + 9 = 21 appearances starting with "v2017_50_2_BO_UG_7").

Thanks for the help.

Andy Heinzer

If you specifically have only two different strings you want to see in the same search results, perhaps try this instead,

(comment ~ "v2017_50_2_BO_UG_7" OR comment ~ "v2017_50_2_BO_UG_7test1")

I would expect this to return the 21 expected. I understand if this search is not desirable if you have multiple similar terms to search, however I believe that what you have seen here so far is a limitation of Jira's whole word searches I mentioned previously.

If you are looking to use a different solution here, you might examine Adaptavist's Scriptrunner. This plugin to Jira provides some extended JQL functions, including the ability to use regular expressions as a means to search issues in Jira.

Sandra Meessen

Hello Andrew, I don't have these 2 strings expected, actually there are (at the moment) about 25, al startin with "v2017_50_2_BO_UG" followed by other characters. At the moment my search query looks like you suggest "comment ~ "v2017_50_2_BO_UG_7" OR comment ~ "v2017_50_2_BO_UG_7test1 OR ..... OR... OR..... (25 times)". So this search query does not look efficient and not very readable. Therefore I'm looking for alternative.

When I try the Scriptrunner option "issueFunction in issueFieldMatch("project = QSD", "comment", "v2017_50_2_BO_UG_\\d{1}")" I get an errormessage "Error occurred communicating with the server. Please reload the page and try again.". Errormessage on scriptrunner search options.JPG

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

wildcard