The "edit search query" option disappears in the new Jira issue macro when an unsupported sort field is added to the JQL

XMLWordPrintable

    • 2
    • Severity 3 - Minor

      Issue Summary

      The "edit search query" option disappears in the new Jira issue macro when an unsupported sort field is added to the JQL

      This is reproducible on Data Center: (yes) / (no)

      Steps to Reproduce

      1. Create a JQL that has the unsupported sort field in the ORDER BY field. eg: 
        project in (TEST) and type in (ISSUE) ORDER BY created DESC, type, cf[10003] 

        If the same query is run on Jira you will see the error 

        Field 'cf[10003]' does not support sorting. 

        If the same query is run on Jira legacy macro you will see the message:

        The Jira server didn't understand your search query. If you entered JQL, please ensure that it's correctly formed. If you entered an issue key, ensure that it exists and you have permission to view it. Learn More 
      2. Create a page in Confluence and add the new Jira issue macro with the above query
      3. Publish the page
      4. Edit the page
      5. Edit the macro

      Expected Results

      The "edit search query" option should be shown in the edit pulldown and user should be able to edit the query.

      Actual Results

      The "edit search query" option in the edit pulldown is gone

      Workaround

      • Edit the page 
      • Click the edit link button
      • Copy the link and open it in a new browser tab
      • If the field is not supported for sorting you will see the below message
      • Remove the unsupported field and refresh. For example in the above screenshot remove cf[10003] from ORDER BY
      • Remove the key from the URL and copy the URL. For eg:
        https://instance.atlassian.net/issues/ISSUE-20?jql=project%20in%20%28CSE%29%20and%20type%20in%20%28Epic%29%20ORDER%20BY%20created%20DESC%2C%20cf%5B10025%5D%2C%20cf%5B10024%5D%2C%20type 
        
        Remove the ISSUE-20 from the URL
        
        https://pgundemeda.atlassian.net/issues/?jql=project%20in%20%28CSE%29%20and%20type%20in%20%28Epic%29%20ORDER%20BY%20created%20DESC%2C%20cf%5B10025%5D%2C%20cf%5B10024%5D%2C%20type
      • Copy the updated URL
      • Go to the Page and edit the Jira issue macro.
      • Click on the Edit link buttom and page the URL in the Search or paste a link section and click Save
      • Now you can see the drop-down option to see the "edit search query"

            Assignee:
            Unassigned
            Reporter:
            Pavani
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: