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

As a Jira user, I want to be able to run a JQL search with special characters

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • JQL
    • 23
    • 11
    • Hide
      Atlassian Update – 11 May 2019

      Hi everyone,

      Thank you for highlighting the inconsistency in our documentation. We've updated the documentation regarding special characters in Jira 8.x and 7.x releases as described in JRASERVER-63730.

      You cannot search for special characters because they're not stored in the index. The index only keeps text and numbers. In versions before 8.x you could use special characters to combine two separate terms into a phrase, for example "Jira+Software" or "Jira/Software". The exact phase search has changed in JIra 8.0. You can check our documentation for more details.

      Katarzyna Derenda
      Product manager, Jira Server

      Show
      Atlassian Update – 11 May 2019 Hi everyone, Thank you for highlighting the inconsistency in our documentation. We've updated the documentation regarding special characters in Jira 8.x and 7.x releases as described in JRASERVER-63730 . You cannot search for special characters because they're not stored in the index. The index only keeps text and numbers. In versions before 8.x you could use special characters to combine two separate terms into a phrase, for example "Jira+Software" or "Jira/Software". The exact phase search has changed in JIra 8.0. You can check our documentation for more details. Katarzyna Derenda Product manager, Jira Server
    • 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.

      Problem Definition

      Unable to search using JQL for strings containing special characters. The proper escape characters were used. Example of string:

      [Toto]

      Search using JQL below:

      summary ~ "\\[Toto\\]"
      Expected Results
      1. [TOTO] test 1
      2. Test 2[Toto]
      3. [Toto]test 3
      Actual Results
      1. [TOTO] test 1
      2. Test 2[Toto]
      3. [Toto]test 3
      4. toto test 4
      5. "toto" test 5

      As seen from the actual results, searching for :

      summary ~ "\\[Toto\\]"

      is the same as searching for

      summary ~ "Toto"

      Suggested Solution

      Allow JQL searches with special characters.

      Workaround

      Search using the custom field ID instead. The custom field ID is usually shown beside the custom field name when typing it in Advanced Searching.

          Form Name

            [JRASERVER-66244] As a Jira user, I want to be able to run a JQL search with special characters

            Mônica Bohrer da Silva added a comment -

            Olá!

             

            Em um projeto usamos o summary padrão [xxxx - xxx - xxxxx], consegui resolver fazer a pesquisa summary ~ "TESTE?*".

            Mônica Bohrer da Silva added a comment - Olá!   Em um projeto usamos o summary padrão [xxxx - xxx - xxxxx] , consegui resolver fazer a pesquisa summary ~ "TESTE?*".

            Mônica Bohrer da Silva added a comment -

            Olá!

            Eu consegui resolver usando summary ~ "TESTE?*"

            Mônica Bohrer da Silva added a comment - Olá! Eu consegui resolver usando summary ~ "TESTE?*"

            rmouysme79 added a comment -

            https://twitter.com/salvatorep53020/status/1671229795332669443
            https://twitter.com/yolandadel19173/status/1671230159561842688
            https://www.facebook.com/permalink.php?story_fbid=pfbid0tehKyo188J4RABth7h4n741y5LbZsdGdvKAwVgXV18isfUvA33CAy2BTzzNYyGb7l&id=100093811296344
            https://www.scoop.it/topic/jsbmoons/p/4145168270/2023/06/20/meer-nandla-elsiu-com-reviews-must-read-this-before-buying
            https://www.scoop.it/topic/ednagibbs1/p/4145167527/2023/06/20/meer-nandla-elsiu-com-reviews-must-read-this-before-buying
            https://www.quora.com/profile/Jsbmoons/Elsiu-Com-Reviews-Is-It-Legit-or-Scam-https-meernandla-blogspot-com-2023-06-elsiucom-reviews-must-read-this-before
            https://www.flickr.com/photos/198568708@N07/52989811968/in/dateposted-public/
            https://www.metooo.io/e/elsiu-com-reviews-too-good-to-be-true
            https://djpod.com/sandydelgado/elsiu-com-reviews-is-this-website-selling-the-best-women-clothing

            rmouysme79 added a comment - https://twitter.com/salvatorep53020/status/1671229795332669443 https://twitter.com/yolandadel19173/status/1671230159561842688 https://www.facebook.com/permalink.php?story_fbid=pfbid0tehKyo188J4RABth7h4n741y5LbZsdGdvKAwVgXV18isfUvA33CAy2BTzzNYyGb7l&id=100093811296344 https://www.scoop.it/topic/jsbmoons/p/4145168270/2023/06/20/meer-nandla-elsiu-com-reviews-must-read-this-before-buying https://www.scoop.it/topic/ednagibbs1/p/4145167527/2023/06/20/meer-nandla-elsiu-com-reviews-must-read-this-before-buying https://www.quora.com/profile/Jsbmoons/Elsiu-Com-Reviews-Is-It-Legit-or-Scam-https-meernandla-blogspot-com-2023-06-elsiucom-reviews-must-read-this-before https://www.flickr.com/photos/198568708@N07/52989811968/in/dateposted-public/ https://www.metooo.io/e/elsiu-com-reviews-too-good-to-be-true https://djpod.com/sandydelgado/elsiu-com-reviews-is-this-website-selling-the-best-women-clothing

            Carol Rincon added a comment - - edited

            @Lisa Ballard, I tested your suggestion on my system and the search results have instances without brackets, with a colon, or with parenthesis instead of brackets; hence, the brackets are just ignored in the JQL.

            Furthermore, following your example, using "FE" (instead of "\"[FE]\"") yields the exact same results even though not all stories follow that same pattern.

            Carol Rincon added a comment - - edited @Lisa Ballard, I tested your suggestion on my system and the search results have instances without brackets, with a colon, or with parenthesis instead of brackets; hence, the brackets are just ignored in the JQL. Furthermore, following your example, using "FE" (instead of "\" [FE] \"") yields the exact same results even though not all stories follow that same pattern.

            Lisa Ballard added a comment -

            this is working for us, to find [FE]:


            summary ~ "\"[FE]\""

            Lisa Ballard added a comment - this is working for us, to find [FE] : summary ~ "\" [FE] \""

            Georg DE added a comment - - edited

            I need to find issues containing specific XML character references like 

            ž

             for the letter ž or 

            

             for replacement character. Similar tasks for entities in HTML, DTD etc. exist. It's simply not feasible to manually open thousands of issues, unfold their comments, and search using the browser search function.

            Georg DE added a comment - - edited I need to find issues containing specific XML character references like  ž  for the letter ž or    for replacement character. Similar tasks for entities in HTML, DTD etc. exist. It's simply not feasible to manually open thousands of issues, unfold their comments, and search using the browser search function.

            Arvind Saini added a comment -

            Please consider for fixation as that will help. Seems like it had been fixed against JRASERVER-25092 in past and somehow not working. Jira version, i have (v8.20.10#820010-sha1:ace47f9).

            Arvind Saini added a comment - Please consider for fixation as that will help. Seems like it had been fixed against JRASERVER-25092 in past and somehow not working. Jira version, i have (v8.20.10#820010-sha1:ace47f9).

            Tomas Karas added a comment -

            petar.petrov: get comfortable: https://jira.atlassian.com/browse/JRASERVER-1391

            Tomas Karas added a comment - petar.petrov: get comfortable: https://jira.atlassian.com/browse/JRASERVER-1391

            petar.petrov added a comment -

            This is really annoying. Aren't 300+ votes enough to gather interest?

            petar.petrov added a comment - This is really annoying. Aren't 300+ votes enough to gather interest?

            Idan Levi added a comment -

            Is this for real?
            Please fix this BUG, unbelievable...

            Idan Levi added a comment - Is this for real? Please fix this BUG, unbelievable...

              Unassigned Unassigned
              llee2@atlassian.com Lenard Lee
              Votes:
              358 Vote for this issue
              Watchers:
              174 Start watching this issue

                Created:
                Updated: