Uploaded image for project: 'Jira Service Management Cloud'
  1. Jira Service Management Cloud
  2. JSDCLOUD-9885

Not able to select an object on issue view when Filter scope contains ORDER BY

    XMLWordPrintable

Details

    Description

      Summary

      Not able to select an object on issue view when Filter scope contains ORDER BY

      Steps to Reproduce

      1. Create an Insight object type custom field
      2. To the filter scope if Insight object, add an IQL that includes the ORDER BY clause:
        Objecttype ="Phone" ORDER BY label
        
      1. Associate the custom field with an issue type and try to add the object for the issue

      Expected Results

      You should be able to set the object in the object custom field.

      Actual Results

      You can browse the objects, but when you try to select an object you receive the following error:

      We couldn't retrieve the Insight object details
      Refresh the page and try again

      Notes

      In the developer console we receive the following error that suggests that it happens because, while editing the object type custom field, there is an additional AND statement included at the end of the IQL mentioned in the Filter scope, and that causes the invalid syntax for IQL:

      {"errorMessages":[],"errors":{"customfield_16718":"IQL \"objectSchemaId = 2 AND  Objecttype =Phone ORDER BY label AND (objectId IN (179))\" has invalid syntax at position  with error message \"extraneous input 'AND' expecting {<EOF>, ' '}\""}}
      

      Workaround

      Remove the ORDER BY clause from the filter scope IQL

      Attachments

        Issue Links

          Activity

            People

              7260236ab89d Justin King
              skahol Swati Kahol
              Votes:
              28 Vote for this issue
              Watchers:
              23 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: