Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-21372

Allow exact-text searching in JQL

XMLWordPrintable

    • 75
    • 5
    • Hide
      Atlassian Update - 30 May 2023

      Dear Customers,

      Thank you for taking the time to file and comment on this issue. We hear your feedback.

      We are now investigating the technical possibility of allowing exact-text searching in JQL. This means not only coding a proof of concept, but more importantly running performance tests to ensure this new feature does not impact negatively Jira Data Center stability.

      We are planning to come back with another update within 3 months.

      Kamil Cichy
      Senior Software Developer
      Jira Data Center

      Show
      Atlassian Update - 30 May 2023 Dear Customers, Thank you for taking the time to file and comment on this issue. We hear your feedback. We are now investigating the technical possibility of allowing exact-text searching in JQL. This means not only coding a proof of concept, but more importantly running performance tests to ensure this new feature does not impact negatively Jira Data Center stability. We are planning to come back with another update within 3 months. Kamil Cichy Senior Software Developer Jira Data Center
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Currently there is no way to find an exact string using the text ~ or comment ~, etc, notations. Could we add another operator, something equivalent to 'contains exactly'?

      E.g. project = JIRA and text ~~ "this string of text" would return all JIRA project issues with "this string of text", with the individual words in that order.

        1. Exact search text.png
          Exact search text.png
          53 kB

          Form Name

            [JRASERVER-21372] Allow exact-text searching in JQL

            Daniel Grut added a comment -

            We might need help from unexpected places.. ca3928d934ca 

            Daniel Grut added a comment - We might need help from unexpected places.. ca3928d934ca  

            myuceel added a comment -

            This request feels like it’s been on the same journey as the One Ring—long and full of challenges! 

            I’m just hoping that one day it reaches its ‘Mount Doom’ and we finally get that exact match feature in JQL.

            Until then, I’ll be here like Samwise, waiting faithfully for the day it all comes together.

            myuceel added a comment - This request feels like it’s been on the same journey as the One Ring —long and full of challenges!  I’m just hoping that one day it reaches its ‘Mount Doom’ and we finally get that exact match feature in JQL. Until then, I’ll be here like Samwise, waiting faithfully for the day it all comes together.

            Petr Cipera added a comment - - edited

            This seems like a simple fix. How come this is 14 years old?

            Petr Cipera added a comment - - edited This seems like a simple fix. How come this is 14 years old?

            Michael Mohr added a comment -

            I'm also tired of waiting for a functionality that should be there since the beginning: A simple JQL with a equal operator to search for issues where a text filed as exactly the same content as the given string instead of only the FTR based contains operator. Because only wit such a operator real duplicates could be prevented while ticket creation, as long as a field can't be set to a unique policy.

            For sure a regex operator would be even more beneficial, but Atlassian is reacting so slow to enhancement requests (as you can see on this request). That a small step like providing a equal to JQL operator for text fields should even be manageable by them.

            Michael Mohr added a comment - I'm also tired of waiting for a functionality that should be there since the beginning: A simple JQL with a equal operator to search for issues where a text filed as exactly the same content as the given string instead of only the FTR based contains operator. Because only wit such a operator real duplicates could be prevented while ticket creation, as long as a field can't be set to a unique policy. For sure a regex operator would be even more beneficial, but Atlassian is reacting so slow to enhancement requests (as you can see on this request). That a small step like providing a equal to JQL operator for text fields should even be manageable by them.

            David Pontarelli added a comment -

            This would be very useful. How is it not a thing still??

            David Pontarelli added a comment - This would be very useful. How is it not a thing still??

            Madeleine Duke added a comment -

            No worries, I love Portal, I just thought you might all enjoy the cake (what with it being all of our personal tortures to follow this issue)

            Madeleine Duke added a comment - No worries, I love Portal, I just thought you might all enjoy the cake (what with it being all of our personal tortures to follow this issue)

            Andrew Quee added a comment -

            That's amazing, love the colour scheme!  Sorry if I sounded negative towards you - the cake reference is a Portal game in-joke.  "The cake is a lie" representing extreme efforts towards an imaginary promised goal.  See you all again for this issue's University/College graduation.

            Andrew Quee added a comment - That's amazing, love the colour scheme!  Sorry if I sounded negative towards you - the cake reference is a Portal game in-joke.  "The cake is a lie" representing extreme efforts towards an imaginary promised goal.  See you all again for this issue's University/College graduation.

            Greg Antonellis added a comment -

            Madeline Duke did bring in a cake as she said she would:  https://postimg.cc/WDFYLGbL

            Greg Antonellis added a comment - Madeline Duke did bring in a cake as she said she would:  https://postimg.cc/WDFYLGbL

            Daniel Grut added a comment - - edited

            To be sung in the Happy Birthday song melody:

            We need exact search,
            In JQL now,
            Help us find results,
            Please show us how!

            Grant us this feature,
            Make it come true,
            Exact search in JQL,
            We ask of you!

            Author: ChatGPT

            Happy 14th birthday https://jira.atlassian.com/browse/JRASERVER-21372!

            🎂 

            Daniel Grut added a comment - - edited To be sung in the Happy Birthday song melody: We need exact search, In JQL now, Help us find results, Please show us how! Grant us this feature, Make it come true, Exact search in JQL, We ask of you! Author: ChatGPT Happy 14th birthday https://jira.atlassian.com/browse/JRASERVER-21372 ! 🎂 

            Andrew Quee added a comment -

            At this point having followed it for over ten years, I'm pretty tired of it.  Is the cake even real?  I suspect by now Atlassian is just letting us chill out in the corner seeing as the version most affected (v5) is now well beyond End of Life and alphanumeric searching is 'mostly' fixed as I reported below (I'm using v9.4.5#940005 now).

            "Versions earlier than those listed below have reached End of Life (EOL).  "

            (earliest) "9.0 (EOL date: 21 Jun 2024)"

            Atlassian Support End of Life Policy

            Andrew Quee added a comment - At this point having followed it for over ten years, I'm pretty tired of it.  Is the cake even real?  I suspect by now Atlassian is just letting us chill out in the corner seeing as the version most affected (v5) is now well beyond End of Life and alphanumeric searching is 'mostly' fixed as I reported below (I'm using v9.4.5#940005 now). "Versions earlier than those listed below have reached End of Life (EOL).  " (earliest) "9.0 (EOL date: 21 Jun 2024)" Atlassian Support End of Life Policy

              Unassigned Unassigned
              jsloat John Sloat (Inactive)
              Votes:
              563 Vote for this issue
              Watchers:
              256 Start watching this issue

                Created:
                Updated: