# Self join within a smart folder

**URL:** https://community.fibery.io/t/self-join-within-a-smart-folder/4908
**Category:** Bugs & Issues
**Created:** [August 5, 2023, 7:19pm UTC](https://community.fibery.io/t/self-join-within-a-smart-folder/4908 "2023-08-05T19:19:42Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![DiegoKamp](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/diegokamp/32/4588_2.png) [@DiegoKamp](https://community.fibery.io/u/DiegoKamp)
#### Post date: [August 5, 2023, 7:19pm UTC](https://community.fibery.io/t/self-join-within-a-smart-folder/4908/1 "2023-08-05T19:19:42Z")

</div>

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](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/b8d369e4695026628d8149bd086b1895ac7b20cc.png)

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.

---

<div class="post-metadata">

### Author: ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [August 7, 2023, 6:31am UTC](https://community.fibery.io/t/self-join-within-a-smart-folder/4908/2 "2023-08-07T06:31:20Z")

</div>

Same/similar

> [@No "hierarchical" option in List views for second-level DB?](https://community.fibery.io/t/no-hierarchical-option-in-list-views-for-second-level-db/4049):
>
> 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: Here the hierarchical option is not available for the same DB when it appears at the second level: