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.