Entity context lookup: related field lookup list of relations, not allowing filters and search

I have a one-to-many relationship with a lookup against a one-to-many. Relationship below.

[A] 1 — * [B] 1 — * [C]

In this situation, I want to list all of C in the context of A.

So on the A database, I created a lookup against B’s list of C entities.

This works fine for pulling the data through, but it doesn’t allow:

  • displaying in a table (just a list)
  • filtering or searching the resultant list

Add a relationship from a to C. This relationship will always stay empty, in the description of the field leave a note tgats to make a view and to keep it empty. You can also add a relation filter for where public ID is -1, this the drop-down will always be empty.

Then in the entity view, go to this new relation, and press on “Filter” and the it will say “Show C from a” press on C, and it will give you the option to show c from B from a. Now it will act like a lookup but with the ability to create, and show as any layout. Down side is that it makes a fake relationship, but until this: Add Views to Entities makes systems or this: Add a view of "Collection" entities within another entity that are not related, just for reference
I think this is the only option.

Note that in table view this fake relationship should be off, and the lookup should be on. As this complex filtering only works in entity view and not in a compact list unfortunately.

Lmk if it works!

I could do this…

Daga kotowaru

I’ll just tell users that it’s not possible at this time.

Also, if entities get true views… then we could be seeing entity context dashboards in the future :eyes:

Hahah okay.

Because it adds fake data fields or?

I hope so!! That’s ideal direction I think for entity view. To treat it like a dashboard. What if entity view was treated as a dashboard? But they said it’s much more complex to build a dashboard layout for entity view than the normal dashboard view. So Idk how long that will take.

I see as it potentially just being another tab view which you can expand to full-screen. Use some smart CSS to wrap the columns/grid to half-size when viewed in a split panel. Could work

1 Like

Maybe you want to vote for this: