• 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.

      In the * list view, * Filtered Search (Search for object menu), and * Report listsI want to be able to add columns that are referenced two or several steps away (third, forth,.. level) from the object list-view that is currently being displayed.The reason for this is that when analyzing the data in Insight, the information in the references is often needed, and having all relevant data in the same view would make it much easier to do the analysis.*Proposed solution*Enable users to add columns using the dot-notation similar to what is used in IQL *Example use case Continent for Stores*I have created three object types with relations: Store, Country and Continent. See attached schema export [^RPS-13463_example_schema.zip].I would like to list all Stores with their continent that has a continent name like 'A'. Using IQL: objectType = Store AND "Country"."Continent" LIKE "A"I would like the result in the search view to be:

      Store               Country         ContinentBeijing             China           AsiaHyderabad           India           AsiaMontreal            Canada          North AmericaPhiladelphia        USA             North America

       But I do not see the Continent, see attached screen shot  !Search_result_of_case2.png!The example created here is very small but we hope that we can show what we mean in a simple way. Our true use case is much more complicated with hundreds of rows. Which means that the Catalogue Report, that has a third level object types, will not work - it is not structured for overview of many objects.If doing this in SQL in a database we would have joined the tables and created views and showed the views. We are looking for a similar way of viewing data in third, forth.. level object types related to the original object type.

            [JSDSERVER-7392] View referenced data beyond second level in list results

            SET Analytics Bot made changes -
            Support reference count New: 2
            Marc Dacanay made changes -
            Labels Original: affects-server insight-hs New: affects-server insight-hs ril
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 977028 ]
            Alex Cooksey made changes -
            Labels New: affects-server insight-hs
            Alex Cooksey created issue -

              Unassigned Unassigned
              da0dd4439f59 Alex Cooksey
              Votes:
              3 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: