Skip to main content
Solved

How to create a Tree view in Universal?

  • August 31, 2026
  • 8 replies
  • 94 views

Struggling to even get a tree to shape no matter the options I set, I hope someone could advice me how to get this test scenario to work.

I have a view that has the following columns:

  • parent_id
  • child_id
  • grand_child_id

All columns make the PK.

In an example this is the data (with lookups):
 

 

I want to see something like (structure example, formatting is just for clarity):
Parent A
--Child A
----Grand child A
----Grand child B
--Child C
----Grand child C
Parent B
--Child D
----Grand child D
----Grand child E

I have changed the “Tree” settings under “Subject”. I have tried all combinations at “Tree” under “Component”. Chose different options for “Sort” with and without “Group until”.

The screen type has the “Tree” as its component.

All it ever shows is:
 


Platform 2026.2

I have compared it to an older product that still has the Windows GUI where a tree does work, but to no avail.

What do I need to set to get the result as desired?

Best answer by Mark_Plaggenborg

  

Credits to Harm Horstman for guiding me to the right direction.

Here is how I got it working. The screenshots used are from a testing scenario and not a real implementation. Naming and use of columns might not always make sense. Also not all options are used.

Tree (column):
A table/view with some columns. For a possible icon we have used a domain with elements and the control “image combo”.

columns of table/view

In this case I have used the source tables as a lookup for the name of the “Parent”, “Child”, “Grand child”.

Now go to “Subjects” → “Settings”
 

Subjects → Settings (icon  is optional)


After that go to “Subjects” → “Components” → “Tree”

“Subjects” → “Components” → “Tree”

In the “Parent column” give it the column of which it is the higher node.

Lastly go to “Subjects” → “Data” → “Sort”

“Subjects” → “Data” → “Sort”

Most important there is to set the “Group until” upto the node you which to keep unique before you have it split to the individual values. In this case the “table_child_id” as we want to see each “Grand child”

Here the table with the data:

Table representation

Final result of the tree:

Tree (column)


Tree (hierarchical):
A table/view with some columns. For a possible icon we have used a domain with elements and the control “image combo”. We want the same data, but the structure needs to be made more vertical.
 

columns of table/view

In “column_id” you want to have a unique key. In the “parent_column_id” you match the “column_id” of with it is a child.

Now go to “Subjects” → “Settings”
 

Subjects → Settings (icon  is optional)


After that go to “Subjects” → “Components” → “Tree”

“Subjects” → “Components” → “Tree”

As we have a vertical connection only, we only need 1 “Parent column” filled.
In this case we do not need a “group until” set in the “Sort”

Here the table with the data:
 

Table representation

Final result of the tree:
 

Tree (hierarchical)

 

8 replies

  

Credits to Harm Horstman for guiding me to the right direction.

Here is how I got it working. The screenshots used are from a testing scenario and not a real implementation. Naming and use of columns might not always make sense. Also not all options are used.

Tree (column):
A table/view with some columns. For a possible icon we have used a domain with elements and the control “image combo”.

columns of table/view

In this case I have used the source tables as a lookup for the name of the “Parent”, “Child”, “Grand child”.

Now go to “Subjects” → “Settings”
 

Subjects → Settings (icon  is optional)


After that go to “Subjects” → “Components” → “Tree”

“Subjects” → “Components” → “Tree”

In the “Parent column” give it the column of which it is the higher node.

Lastly go to “Subjects” → “Data” → “Sort”

“Subjects” → “Data” → “Sort”

Most important there is to set the “Group until” upto the node you which to keep unique before you have it split to the individual values. In this case the “table_child_id” as we want to see each “Grand child”

Here the table with the data:

Table representation

Final result of the tree:

Tree (column)


Tree (hierarchical):
A table/view with some columns. For a possible icon we have used a domain with elements and the control “image combo”. We want the same data, but the structure needs to be made more vertical.
 

columns of table/view

In “column_id” you want to have a unique key. In the “parent_column_id” you match the “column_id” of with it is a child.

Now go to “Subjects” → “Settings”
 

Subjects → Settings (icon  is optional)


After that go to “Subjects” → “Components” → “Tree”

“Subjects” → “Components” → “Tree”

As we have a vertical connection only, we only need 1 “Parent column” filled.
In this case we do not need a “group until” set in the “Sort”

Here the table with the data:
 

Table representation

Final result of the tree:
 

Tree (hierarchical)

 


Erik Brink
Moderator
Forum|alt.badge.img+5
  • Moderator
  • September 18, 2026

Hi Mark,

You are totally right about the hierarchical tree type.

For the Column-type tree I would like to add some corrections:

  • Your example does not suite this application. Choose this type when you want to group on a column value, like a status or a country or whatever. The records that match the value will be together in a group.
  • To set it up: set the type and go to tab: Data > Sort > set the group-until checkbox as part of your sorting. This and all columns before will be grouped.
  • For this type, tab: components > Tree is not relevant to set-up.

We are working to describe this well in our Docs.

Best regards,
Erik Brink


Hello Erik,

thanks for the additional explanation. Now looking back at my post, I notice the “Column” tree is not showing the way I wanted it to be anyway as it duplicated the parent under the child again.

Even after removing the component settings, I still get the same result. A grid however is showing the correct result. Very unclear how that “Grouping” should work then.

 

 


Erik Brink
Moderator
Forum|alt.badge.img+5
  • Moderator
  • September 22, 2026

This seems to be a typical Hierarchal tree example, where records of the same subject are related to each other. 

A column tree groups records on the shared column value. For example:
 

At the subjects’ sorting the “Country” and “province” columns are included by the grouping. 

SF (see the “group until” checkbox):
 

 


Edit: Never mind, I figured out the missing link. The lookup field was empty on the tree view. Results are now as one would expect.



--------------------------------------------------------------------------------
Original message:

This is the plain data in the grid when I turn the “Group until” off.
 


Here even with the lookup turned off:



So, If I group until “Child”, that should make row 1 and 2 unique with “Parent A” and “Child A”, right? And then split off to show the “Grand child A” and “Grand child B”?
 



The tree (column) does however this:


And for completeness, the component has nothing set up:
 

 


Erik Brink
Moderator
Forum|alt.badge.img+5
  • Moderator
  • September 22, 2026

You are right. This is proper data for a Column tree. 

This seems like a bug that the parent values are added twice. Can you raise a TCP ticket for that?


We just missed each other in our responses. I have edited the my response in the time you replied as well, but keeping my original response too.

The issue was the missing of the Lookup field on the view or Tree setting if one prefers. Luckily no bug.


  • Thinkwiser
  • September 23, 2026

Hi Mark,

Thanks to your contribution, we have now included topics on how to set up the two Tree types.

You can check them out under the following subject: Subject settings | Thinkwise Documentation

Once again, many thanks on behalf of the Documentation team!