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'."
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$")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
It simply won't allow the "=" operator in any way.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, Nikola, thanks for the quick response.
Suggest to me how to get exact results and values.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have tried same jql issue IN wildcardMatch("Vessel Name[short text]","Willie") not working.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
By not working, what do you mean exactly? Is it showing all of the results with the "Willie" keyword?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are there any issues that were created with the value of Willie only?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What I meant was, are there any tickets that were created having the value of "Willie" only in your custom field?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Navee,
Please try:
project = "Devops" AND "vessel name" ~ "\"willie\""
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for quick response.
It's not working, results willie b and Willie Joe values appeared.
Required only Willie value results
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can also try: project = "Devops" AND "Vessel Name" = "Willie"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If there’s a plugin that can help with this, please let me know as soon as possible
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.