I have a content type called Trip. The Trip is referenced by Trip Entries and each Trip entry has From and To date fields (using Date API) and a City taxonomy term. For instance, a Trip may be "My Thailand Trip" and its entries may be visits to Bangkok and Chiang Mai. The relationship Trip-Trip Entry is via a Node Reference field in the Trip Entry type (each Trip Entry must reference one Trip).
I would like to list all Users (actually, list all Content Profile nodes) who have created Trips that have Entries that pass in a specified City in a specified period. So I need some way to create a Relationship to nodes of a certain Type that the user created (Trip), then get the back reference to the Trip Entry, and finally add exposed filters on Dates and City.
Namely, I need to add a relationship from the Content Profile node to the creating user, then from the creating user to Trip nodes created by that user, then to Trip Entry nodes that reference that Trip node.
Any idea how that can be done using Views solely?
Comments
Comment #1
esmerel commentedThis issue is a year old, it's likely either resolved or no longer relevant.