How to perform an advanced search to find exact results related to a short text field value

naveen arroju
Contributor
August 26, 2024

 

How to perform an advanced search to find exact results related to a short text field value

example : project = Devops and vessel name (short text) ~ willie 


only willie related exact results are needed, not other related willie b willie joe 

 

"How can I perform an advanced search in Jira to find exact matches for a short text field value? For example, I want to search within the 'Devops' project for issues where the 'Vessel Name' field (a short text field) is exactly 'Willie', without returning results that include variations like 'Willie B' or 'Willie Joe'."

4 answers

0 votes
Duc Thang TRAN
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 26, 2024

Hello @naveen arroju 

I don't think it's possible to retrieve only the results for "willie" and exclude "willie c," etc., without using a plugin.

 

I'm using ScriptRunner Here a link to this plugin https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-

Exemple JQL:

issueFunction in issueFieldMatch("project = gtosdmigr", "Text 3", "^willie$")

2024-08-26 10_57_28-Window.png

 

naveen arroju
Contributor
August 28, 2024

Hi Duc Thang TRAN,

Link not working

0 votes
Nikola Perisic
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 26, 2024

Hi @naveen arroju 

You are correct that the "=" operator is not working with your custom field. Even if you try to use something different the only options that you will be given are ~ and IS and IS NOT. Even from the JQL Extensions app, the results are the same.Screenshot 2024-08-26 at 10.00.01.png

It simply won't allow the "=" operator in any way.

naveen arroju
Contributor
August 26, 2024

Yes, Nikola, thanks for the quick response. 

Suggest to me how to get exact results and values.

Nikola Perisic
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 26, 2024

Got it. You would need to download the app JQL Extensions by Appfire. Once that is done, navigate to their application and use the following query:

issue IN wildcardMatch("Vessel Name","Willie")

Let me know the results.

naveen arroju
Contributor
August 26, 2024

I have tried same jql  issue IN wildcardMatch("Vessel Name[short text]","Willie") not working.

Nikola Perisic
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 26, 2024

By not working, what do you mean exactly? Is it showing all of the results with the "Willie" keyword?

naveen arroju
Contributor
August 26, 2024

No Results

Nikola Perisic
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 26, 2024

Are there any issues that were created with the value of Willie only?

naveen arroju
Contributor
August 27, 2024

No there is no issues

Nikola Perisic
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 27, 2024

What I meant was, are there any tickets that were created having the value of "Willie" only in your custom field?

naveen arroju
Contributor
August 28, 2024

Yes there is value with capital letters 

 

 

0 votes
Cristian0791
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 26, 2024

Hi Navee,

 

Please try:

 

project = "Devops" AND "vessel name" ~ "\"willie\""

naveen arroju
Contributor
August 26, 2024

Thanks for quick response.

It's not working, results willie b and Willie Joe values appeared.

 

Required only Willie value results

Cristian0791
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 26, 2024

You can also try: project = "Devops" AND "Vessel Name" = "Willie"

naveen arroju
Contributor
August 26, 2024

"=" not working short text field.

0 votes
naveen arroju
Contributor
August 26, 2024

If there’s a plugin that can help with this, please let me know as soon as possible

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events