I have three custom node types (Batch, Item, Order) that I use to track orders (I don't need the power of full-blown Commerce). These are linked through the following entity reference fields:

Batch->Item through field_items on Batch

Order->Item through field_items on Order

I have a table view set up which shows Items by Batch.

The Question

Is there a way I can display, on the same view, the Order name (if any) that each Item is allocated to?

1 Answer 1


Okay, so I've largely solved this one as follows:

  • The View is set to a table showing content of type Batch
  • I've added two relationships. The first is to items referenced by the content which are of type = Item (and which does not use any relationship). The second is to items having a reference to the content, are of type Order, and use the first relationship
  • I've then added fields from all three content types (using the appropriate relationships) to create the flat table I'm looking for.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.