Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-8666

Insight 'iql_objects_get' REST API does not fetch Inbound references

XMLWordPrintable

    • 3
    • 2
    • We collect Jira Service Desk 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.

      Issue Summary

      Insight REST API does not fetch Inbound references. Only Outbound references are retrievable.

      REST API mentions referenced object in the Response section, but only works for Outbound references.

      Steps to Reproduce

      • Create 3 object Types, for example:
        • Servers
        • Application
        • Location
      • In Server object type, create an outbound reference to Location object Type
      • In Application object Type, create an attribute 'Server', Type Object pointing to Servers object type
      • Create some dummy objects

       

      • Use either of the following REST API
      /rest/insight/1.0/iql/objects?objectSchemaId={id}&iql=objectType=Servers

/rest/insight/1.0/iql/objects?objectSchemaId={id}&includeAttributesDeep=2&iql=objectType=Servers

      Expected Results

      Inbound and outbound reference should be fetched.

      Actual Results

      Only outbound reference are fetched.

      Nothing about Inbound references.

      Workaround

      1) Use an IQL to find all inbound referenced Objects.
      However, if there are many Server objects, it will be required to call REST API as many times as objects are which could be an issue

      The IQL would look like the following:

      {{host}}:{{port}}/rest/insight/1.0/iql/objects?objectSchemaId={id}&iql=object HAVING outR(Key = {ServerKey})

      2) Server object Type could have an outbound reference to Application object type, but we are storing the same data in multiple objects which is not very efficient.

       

        1. image-2021-08-26-16-36-20-719.png
          87 kB
          Pablo Bartolome
        2. image-2021-08-26-16-37-23-338.png
          130 kB
          Pablo Bartolome
        3. image-2021-08-26-16-42-36-687.png
          93 kB
          Pablo Bartolome

          Form Name

            [JSDSERVER-8666] Insight 'iql_objects_get' REST API does not fetch Inbound references

            Marc Dacanay made changes -
            Labels New: ril
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 977875 ]
            SET Analytics Bot made changes -
            UIS Original: 1 New: 3
            SET Analytics Bot made changes -
            UIS Original: 2 New: 1
            SET Analytics Bot made changes -
            UIS New: 2

            Yinon Negev added a comment -

            This is not a bug, hence moved it to Suggestion:

            the API works as expected, and the Workaround mentioned is the valid way to get inbound references, as inbound references are not noted on an object, but they are outbound references of other objects.

            The current syntax (Jira 10.0.0), to get an object (Key=ABC-123) and its inbound references (from ANY schema):

            {{URL}}/rest/assets/latest/aql/objects?qlQuery=Key = ABC-123 OR object HAVING outR(Key = ABC-123)

            Yinon Negev added a comment - This is not a bug, hence moved it to Suggestion: the API works as expected, and the Workaround mentioned is the valid way to get inbound references, as inbound references are not noted on an object, but they are outbound references of other objects. The current syntax (Jira 10.0.0), to get an object (Key=ABC-123) and its inbound references (from ANY schema): {{URL}}/ rest /assets/latest/aql/objects?qlQuery=Key = ABC-123 OR object HAVING outR(Key = ABC-123)
            Yinon Negev made changes -
            Affects Version/s Original: 4.16.0 [ 95090 ]
            Workflow Original: JAC Bug Workflow v3 [ 4201061 ] New: JAC Suggestion Workflow 3 [ 4486829 ]
            Issue Type Original: Bug [ 1 ] New: Suggestion [ 10000 ]
            Priority Original: Low [ 4 ]
            Status Original: Gathering Impact [ 12072 ] New: Gathering Interest [ 11772 ]
            SET Analytics Bot made changes -
            Support reference count Original: 1 New: 2
            Tiziana Marchionni made changes -
            Remote Link Original: This issue links to "Page (Confluence)" [ 926635 ]
            Tiziana Marchionni made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 926635 ]

              Unassigned Unassigned
              9f03f4114502 Pablo Bartolome
              Votes:
              4 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated: