Day 1: Database "join" scenario was difficult until I found the trick! Plus other thoughts

[Philipp_II]

Hello,

I was just browsing through the forum because I wanted to see if there is already any discussion about adding more advanced database queries to Anytype, which allows me to pull in more information from related objects when viewing sets. Maybe something like a Join operation in SQL. Or something like the Rollup-feature in Notion. (I have never used Notion, but the way the rollup is explained on their website sounds like a useful feature. Although even Notion’s rollups are still a bit limiting because you cannot do rollups of rollups. So you can navigate only one step from the current object.) Now I have stumbled over this thread and I am a bit confused. Does this mean that there is actually already more functionality available in Anytype, that I am just not aware of because it is poorly documented?

Automatic Bi-directional linking + Rollups

Is your feature request related to a problem? Please describe. In Notion there is a way to make two-way/synced relations. In Anytype there is currently no way to reflect a two-way relation directly in sets expect for having a normal-relation and then looking into the navigation dialog of an object to find out which relation is linking to this object of the same type. But I think this can be a bit clunky if you want to use some sort of two-way relation. Describe the solution you’d like I can t…

why is there a feature request for rollups, if this feature is already available?

How did you do this relational lookup? Is this “relational lookup” something like this “rollup” that notion explains on their website? Or have I misunderstood this?