We are working with three related collections: Record A, Record B, and Record C.
- Each Record B is linked to one Record C.
- Each Record B can have multiple Record A entries.
- Record C is linked to the Users collection (many-to-one).
We want to build a chart that shows the number of Record A entries grouped by the username in Users (via Record C).
While configuring the chart, I can access the relationship Record A → Record B, but I cannot traverse further to get the username field in Users through Record C (i.e., Record A → Record B → Record C → Users.username).
This is a critical requirement for our use case. Is there any supported way to achieve this in NocoBase?
Hi Team. Any insights on this issue?
The association hierarchy is quite deep. For performance reasons, we limit the depth of associations. You might consider creating a dedicated SQL table and using custom SQL queries instead.
While, I can create the table, I wont be able to leverage the powerful filters which are available on the original table as the table created using SQL doesn’t support reference fields.
Currently, NocoBase charts support traversing only one level of relationships for grouping. Since your requirement involves multiple levels (Record A → Record B → Record C → Users.username), it is not directly supported.
A possible workaround is to create a view or a computed field on Record A that stores the related Users.username by fetching it through Record B and Record C. Then use this field for chart grouping.
Alternatively, consider exporting the data and using an external tool for such multi-level grouping.
Thanks for the response. I tried using Formula field, but that too doesn’t support dot-walking. How can I achieve this using computed field?