I have the following problem I can't figure out how to solve - note I am a Drupal newbie...
I have two content types; TypeA and TypeB. TypeA includes an entity reference field of TypeB to create a static relationship, similar to a "related work" or "is part of" use case.
This relationship displays fine in the full display mode for TypeA and all is well on that front.
I fail, however, to display this relationship as a mapping table in a third content type, where all TypeB nodes represents columns, and all TypeA nodes are displayed in individual rows like the following example:
Example:
Consider we have the following three nodes of TypeB: NodeA, NodeB, and NodeC.
We also have 5 nodes of TypeA, all along with the following relationships to TypeB nodes as follows:
- Node1 (NodeA, NodeC)
- Node2 (NodeA)
- Node3 (NodeB, NodeC)
- Node4 ()
- Node5 (NodeA, NodeB, NodeC)
The mapping table then would look like this:
| NodeA | NodeB | NodeC
------|-------|-------|------
Node1 | X | | X
------|-------|-------|------
Node2 | X | |
------|-------|-------|------
Node3 | | X | X
------|-------|-------|------
Node4 | | |
------|-------|-------|------
Node5 | X | X | X
Obviously, I do not want to maintain this table manually, but be built depending on the actual dynamic content of the site.
EDIT
The following constraints also apply (forgot to mention them in the first place):
- When I unpublish or delete a node of content type TypeB, the entire column of this mapping table needs to disappear
- The view (anticipating that I can implement this through crafty Views configuration) should not be cached, or cache-cleared upon change (is that even possible?)
- The "X" in the example table would ideally be replaceable with other code or content I control (e.g. a little image, or glyph or so)
Thanks a lot,
Michel