Unfortunately, and as we all know, in smart folders (and in list), the representation of self joins is not possible. Here is an example: project → task → subtask As you can see, the subtask is flattened to the level of the parent task. How can I represent projects hierarchically if I don’t have this functionality? [immagine] It works if the table in self join is placed the first level of the smart folder or list. So the only way is to represent the project as a top-level task, but as you know the project has fields other than the task, these project-specific fields would remain empty for the records representing the tasks. This is a problem that has been waiting for a solution for a long time. I mainly use Fibery for knowledge management and do well, but reading that this application was born mainly for work flow and project management, I am surprised that this structural problem, which in my opinion is not insignificant, is not yet addressed. The architecture project → subproject → task → subtask → subtask etc. is the basis for project management. Best regards.

Same/similar [image] No "hierarchical" option in List views for second-level DB? Get Help I don’t understand why the List view’s “Hierarchical” option for a tree-structured DB is only available if the DB appears at the top level of the List view: [image] Here the hierarchical option is not available for the same DB when it appears at the second level: [image]

Self join within a smart folder

Bugs & Issues

Chr1sG August 7, 2023, 6:31am 2

Same/similar

Topic		Replies	Views
[DONE] Display recursive relationship (task -> subtask) when it's not the "first level"? Get Help	5	352	November 8, 2023
Smart folder vs list Misc	1	72	September 20, 2024
Representing nested relations Ideas & Features	31	3925	February 12, 2026
Task "belonging" to folder Ideas & Features	7	428	December 12, 2022
(Smart Folder) Show same database on multiple levels Ideas & Features context-empire	4	116	March 31, 2026

Self join within a smart folder

Related topics