I am trying to create a View that produces 1 stop itineraries. I have a content type
"Route", with the following fields.
From To Method
The data looks like:
From | To | Method A | B | Method 1 A | Z | Method 3 B | C | Method 3 Z | C | Method 3
If a user searches
"To: C", the view should return:
From | To | From | To | A | B | B | C | A | Z | Z | C |
which ultimately results in B and Z as the intersection points (and a more friendly output to the user).
From | Via | To A | B | C A | Z | C
For the life of me, I cannot figure out how to produce this join against the route table.
Any advice? I have even replicated the Route content type to
"Route 2", and attempted a relationship on the inner
"To" fields of Route and Route 2, but cannot produce this expected output.