Please see this 4 min video to explain the issue:
hidden link
Custom Type 'Produtions' can have multiple Custom Type 'Members ' associted with it.
Some of those members have 'Principal Credits' for a given production eg. Directed by
I need to display all members that have a principle credit on a page template in a certain place.
I have been trying using the View 'Productions - Principal Credits' but can't do it.
Thanks
---
John
Okay so you've got a custom field on the Members to Productions relationship, and you want to filter a list of Members using that custom field value. The only way to filter a list by a custom field is if that custom field exists on the post type in your View's content selection. In other words, you must create a View of the intermediary Members to Productions post type in order to filter by the Principal Credit field. It looks like you have disabled publicly_queryable for the Intermediary post type in post type settings. I changed that for you, then changed the View to use the Intermediary post type in the Content Selection. I added a post relationship View to show only intermediary posts related to the current Member post, and I also added a Query Filter for the Principle Credit field so that it's not equal to blank. I also updated the loop template for this View:
[types field='principle-credit'][/types]: <strong>[wpv-post-title item="@members-to-productions.parent"]</strong><br />
The principle-credit field is there, along with the title of the Member post. Take a look and let me know if you see anything misbehaving.
Christian thank you...this may seem very 'normal' to you but I would never have done that and it looks like it is working very well. I really appreciate you taking the time on this.
The only outstanding issue is the order in which the Principal Credits appear on the page. The Crucible as a case-in-point - currently the Co-Director comes before the Director. I need an easy way to stipulate the order of the principal credits?
Again thanks Christian
---
John
Also...
Is there any way to get back and edit the Members allocated to a production. I mean the pop-up that appears when I 'connect an existing member' Where I add the 'Name of Role/Part/Job' the Production - SUB Team and add the Principal Credit if appropriate.
Eg. In 'The Crucible' if I want to remove the principle credit for Lucy WInston, the only way I can see to do this is to disconnect her and the re-connect her (I just want to amend the connection) - this is very longwinded! As other members will be inputting this information I need a 'fool-proof and easy ' method.
Thanks Christian
I need an easy way to stipulate the order of the principal credits?
The easiest way is to add another custom field to the Members to Productions relationship, and use it to store a numeric value indicating the sort order. If you need different sort orders, you'll need multiple order fields.
Is there any way to get back and edit the Members allocated to a production. I mean the pop-up that appears when I 'connect an existing member' Where I add the 'Name of Role/Part/Job' the Production - SUB Team and add the Principal Credit if appropriate.
Not if the intermediary post type is hidden in wp-admin. If you had a visible intermediary post type, then you would be able to edit each field without needing to disconnect and reconnect the posts.
