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

Impossible to distinguish between a space and an underscore in a search query

      We just started using Jira here (3.11). We have thousands of commonly used terms
      in our company that have underscores in them and so a high percentage of our search
      queries will contain underscores. It is currently impossible for us to do these searches in
      Jira.

      Jira seems to treat the underscore character to be identical to a space character.
      For instance if I want to do a search that will match all words that start with "abc_",
      I get the following results.

      Search for:
      abc_
      Matches:
      abc_def (correct)
      abc_hij (correct)
      abc klm (wrong)
      abc def (wrong)

      Search for:
      "abc_"
      Matches:
      abc_def (correct)
      abc_hij (correct)
      abc klm (wrong)
      abc def (wrong)

      Search for:
      "abc_def"
      Matches:
      abc_def (correct)
      abc def (wrong)

      Search for:
      "abc def"
      Matches:
      abc_def (wrong)
      abc def (correct)

      I looked at the Lucene documentation, but underscore is not one of their reserved
      characters, so it appears that this behavior is coming from somewhere inside Jira.

            [JRASERVER-14641] Impossible to distinguish between a space and an underscore in a search query

            The issue is still happening in one case I tested.

            For example:

            text~\"Search_Item\"

            -It doesn't happen when doing the search inside Jira (by selecting jql search instead of basic)

            I type in the search box: text~\"Search_Item\"

            and it works as intended.

             

            -It doesn't happen when using the Rest API, and having it as Url arguments, for example:

            https://Jira.net/rest/api/3/search/?jql=text~\"Search_Item\"

            GET http method

            works as intended.

             

            It however happens when doing a POST method, maybe something with my setup, or might be a bug in Jira

            but I do get the issue when using POST.

            For example:

            {"jql": "text~\"Search_Item\""}

            The issue happens.

            Ali Jakamy added a comment - The issue is still happening in one case I tested. For example: text~\"Search_Item\" -It doesn't happen when doing the search inside Jira (by selecting jql search instead of basic) I type in the search box: text~\"Search_Item\" and it works as intended.   -It doesn't happen when using the Rest API, and having it as Url arguments, for example: https://Jira.net/rest/api/3/search/?jql=text~\ "Search_Item\" GET http method works as intended.   It however happens when doing a POST method, maybe something with my setup, or might be a bug in Jira but I do get the issue when using POST. For example: {"jql": "text~\"Search_Item\""} The issue happens.

            This ticket should not have been closed.  The exact match method that was fixed in 6.2.3 does still not cater for the main subject of this ticket, which is that the underscore character is still considered as a space in the searching in JIRA.

            Yes, as search such as:

            summary ~ "\"full screen\"" will return only issues that match that exact text, no stemming will be done and stopwords will not be removed.

            is true, but a search for:

            summary ~ "\"full_screen\"" will find summaries that don't contain the underscore.

            Therefore, still not solved.

            Roger Hughes added a comment - This ticket should not have been closed.  The exact match method that was fixed in 6.2.3 does still not cater for the main subject of this ticket, which is that the underscore character is still considered as a space in the searching in JIRA. Yes, as search such as: summary ~ "\"full screen\"" will return only issues that match that exact text, no stemming will be done and stopwords will not be removed. is true, but a search for: summary ~ "\"full_screen\"" will find summaries that don't contain the underscore. Therefore, still not solved.

            Hi cameron.fowler,

            The improvements described in my [https://jira.atlassian.com/browse/JRA-14641?focusedCommentId=716064&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-716064|comment above] have been delivered in JIRA 6.2.3 and above. Hence, the fix version on this issue of "6.2.3".

            Hope that helps

            Regards,

            Oswaldo Hernández.
            JIRA Bugmaster.
            [Atlassian].

            Oswaldo Hernandez (Inactive) added a comment - Hi cameron.fowler , The improvements described in my [https://jira.atlassian.com/browse/JRA-14641?focusedCommentId=716064&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-716064|comment above] have been delivered in JIRA 6.2.3 and above. Hence, the fix version on this issue of "6.2.3". Hope that helps Regards, Oswaldo Hernández. JIRA Bugmaster. [Atlassian] .

            In which version will the fix be available?

            Cameron Fowler added a comment - In which version will the fix be available?

            Hi all,

            We believe that after the changes done at JRA-9240, this use is catered for by using the exact text search syntax:

            Now, performing a JQL search such as:

            summary ~ "\"full screen\"" will return only issues that match that exact text, no stemming will be done and stopwords will not be removed.

            Regards,

            Oswaldo Hernández.
            JIRA Bugmaster.
            [Atlassian].

            Oswaldo Hernandez (Inactive) added a comment - Hi all, We believe that after the changes done at JRA-9240 , this use is catered for by using the exact text search syntax: Now, performing a JQL search such as: summary ~ "\"full screen\"" will return only issues that match that exact text, no stemming will be done and stopwords will not be removed. Regards, Oswaldo Hernández. JIRA Bugmaster. [Atlassian] .

            This search bug is causing problems with our searches. Many issues reference database field and table names that use underscores... so a search for the precise underscore-containing-string tends to return about twenty issues instead of just one or two. Very annoying.

            Mark Symons added a comment - This search bug is causing problems with our searches. Many issues reference database field and table names that use underscores... so a search for the precise underscore-containing-string tends to return about twenty issues instead of just one or two. Very annoying.

            The error that I am receiving from searching with an underscore is actually a little bit different.
            So searching for issues with IT_DR in their summary.
            summary ~ IT_DR ..... this yields results with SAT_DR along with our other results. (simple solution was to say !~ SAT_DR) (try1)
            So I poked around for a bit.
            Seached:
            summary ~ IT_ .... this yields no results at all? (try2)
            summary ~ "\"IT_DR\"" .... same results as (try1). (try3)
            summary ~ "\"_DR\"" ....... same results as (try1). (try4)

            summary ~ "\"T_DR\"" ..... same results as (try2). (try5)
            summary ~ "\"_\"" ............ same results as (try2). This one was weird to me* (try6)

            At any rate, if this could be fixed that would be great.
            In the mean time we will use more complex filters to eliminate unwanted results.

            Brian Smith added a comment - The error that I am receiving from searching with an underscore is actually a little bit different. So searching for issues with IT_DR in their summary. summary ~ IT_DR ..... this yields results with SAT_DR along with our other results. (simple solution was to say !~ SAT_DR) (try1) So I poked around for a bit. Seached: summary ~ IT_ .... this yields no results at all? (try2) summary ~ "\"IT_DR\"" .... same results as (try1). (try3) summary ~ "\"_DR\"" ....... same results as (try1). (try4) summary ~ "\"T_DR\"" ..... same results as (try2). (try5) summary ~ "\"_\"" ............ same results as (try2). This one was weird to me* (try6) At any rate, if this could be fixed that would be great. In the mean time we will use more complex filters to eliminate unwanted results.

            Also linked to https://jira.atlassian.com/browse/JRA-33151 and disappointing this is still not fixed

            There appears to be a bug with Atlassian JIRA concerning their rather poor search functionality - If we can employ holistic searches on our internal Apps it is quite disappointing that a professional software house like Atlassian cannot do something similar.. we do not always know the VEPARSER number .. someone else seems to have reported the bug https://jira.atlassian.com/browse/JRA-33151 s

            See below:

            We are searching for pr_rel_ items (in this case we are looking for VEPARSER-410) if we search the field “SUMMARY” and add pr_ it returns VEPARSER -410 but if we try to narrow down with pr_rel or pr_rel_12M JIRA does not return all items -not at all helpful!!

            mark burpitt added a comment - Also linked to https://jira.atlassian.com/browse/JRA-33151 and disappointing this is still not fixed There appears to be a bug with Atlassian JIRA concerning their rather poor search functionality - If we can employ holistic searches on our internal Apps it is quite disappointing that a professional software house like Atlassian cannot do something similar.. we do not always know the VEPARSER number .. someone else seems to have reported the bug https://jira.atlassian.com/browse/JRA-33151 s See below: We are searching for pr_rel_ items (in this case we are looking for VEPARSER-410) if we search the field “SUMMARY” and add pr_ it returns VEPARSER -410 but if we try to narrow down with pr_rel or pr_rel_12M JIRA does not return all items -not at all helpful!!

            Eric Dalgliesh added a comment - - edited

            Although we've made some other search improvements recently, this issue is not on our short term backlog. It seems simple on the surface but is actually a very large amount of work.

            Please continue to vote if you'd like to see the priority raised.

            Eric Dalgliesh added a comment - - edited Although we've made some other search improvements recently, this issue is not on our short term backlog. It seems simple on the surface but is actually a very large amount of work. Please continue to vote if you'd like to see the priority raised.

            paul grant added a comment -

            When will this bug be resolved?

            paul grant added a comment - When will this bug be resolved?

              Unassigned Unassigned
              3f85ab128771 G B
              Affected customers:
              36 This affects my team
              Watchers:
              31 Start watching this issue

                Created:
                Updated:
                Resolved: