Hello,
Thank you for all your great support!
I managed to figure out one very important view for my site (had to re-do relationships) but having a hard time with this one....the one I figured out is approached the same way but the data I'm accessing is slightly different
(using current version)
CPTs:
Works
Tracks
Publishers
Clients
The Relationships are:
Works - Tracks (one2many)
Works - Clients (many2many) - has intermediary cpt that is VISIBLE called "works-pitches" with fields
Works-Publishers (many2many) - has intermediary cpt that is INVISIBLE with fields
I would like to do the following view as a table (columns not necessarily in this order)
Client Title | Work Title | Track Title | Work-Pitch intermediary Field X | Publisher Title | Publisher intermediary cpt field X |
I'm starting the view from intermediary cpt that is VISIBLE called "works-pitches"
I need to start from there because a single "work" can have multiple clients and want that info to be on it's own row - like so:
Work Title #1 | Client #1
Work Title #1 | Client #2
Work Title #1 | Client #3
I know how to get:
Client Title | Work Title | Work-Pitch intermediary Field X
but I can't seem to figure out how to access the "tracks" attached to each work (in know they will be repeated in one cell)
or the "publishers" attached to each "work"
Basically I want the view to look like the attached image - I'm pretty sure this can be done.....I think 🙂
please see attachment
Thank you!!
Scott.
Dear Scott,
I assume we are talking about a post view querying "works-pitches" posts, and you can display the related "work" post information in the result, with it you can create a child view, querying "tracks" posts, and filter by the post type relation ship "Works - Tracks (one2many)", and display related "tracks" posts.
Same as above, create another child view to display related "publishers" posts
Thank you - I'll need to figure this out later.
Regards