Allow Collection Views to Traverse To-One Relations

Feature Request: Allow Collection Views to Traverse To-One Relations

Problem
Fibery views cannot display collections from a related entity accessed via a To-One relation.
Example:
If Page.MainFrame → Frame, and Frame → Blocks,
there’s no way to show Frame.ContainedBlocks in the Page view.

Current Limitation
The view rendering engine only supports direct collections from the current entity. It does not resolve relation chains like ThisEntity.ToOneRelation.Collection.

Why This Matters
This blocks clean separation between structure (Frame) and content (Block). It forces workarounds like adding backreferences or syncing Block.Page manually.

Request
Allow collection views to traverse one level through a To-One relation.
Example supported patterns:

  • This.MainFrame.ContainedBlocks
  • View filter: Block.ParentFrame = This.MainFrame

Technically Feasible
Fibery already supports this in formulas and the API. The view engine just needs dereferencing support in embedded view configs.

Use Cases:

  • HR: Show Performance Comments in Employee view via → Current Employment Record → Comments
    (Clean To-One, avoids duplicate links and broken ownership)

  • Finance: Show Invoices in Customer view via → Account Profile → Invoices
    (Each customer has one profile; no need for direct invoice duplication)

  • Projects: Show Tasks in Project view via → Active Plan → Tasks
    (Swappable plan structure without schema hacks or view limits)

Why Not Use To-Many Instead of To-One

  • Implies multiple active records—not accurate if only one is valid
  • Requires filtering logic (e.g. “latest by date”)—not supported in views
  • Adds fragility and UI workarounds

Why Not Use Both To-One and To-Many

  • Redundant schema—same data linked twice
  • Risk of desync—can’t guarantee To-One matches filtered To-Many
  • Clutters filters, automations, and user understanding

Better

Use one clean To-One (e.g. Employee → Current Record)
Then enable view traversal:

This.CurrentRecord.Comments

Simple, accurate, and maintainable.