Skip Navigation

[Resolved] Need help with a different view

This support ticket is created 6 years, 5 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

This topic contains 2 replies, has 2 voices.

Last updated by ScottM9386 6 years, 5 months ago.

Assisted by: Luo Yang.

Author
Posts
#919074
Capture.PNG

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.

#919227

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

#919624

Thank you - I'll need to figure this out later.
Regards