Details
-
Bug
-
Resolution: Fixed
-
Low
-
None
-
17
-
Minor
-
14
-
Description
Summary
Not able to select an object on issue view when Filter scope contains ORDER BY
Steps to Reproduce
- Create an Insight object type custom field
- To the filter scope if Insight object, add an IQL that includes the ORDER BY clause:
Objecttype ="Phone" ORDER BY label
- 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
- split to
-
JSDCLOUD-11979 Allow customization of ordering when searching for Assets objects
- Gathering Interest
- is cloned by
-
JDW-3328 Loading...