I have a few custom post types with relationships as follows:
*Teams
* Locations
* Location Fields (child of Location)
* Team Practices (child of teams / Locations / Location Fields)
On my CRED form to add a Team Practice, I have a field for location and one for location field. Is there any way to filter the location field to only those entries belonging to the Location I select (it's listed first on the form)?
Not natively.
The parent Post Pickers will always allow to pick ANY parent Post, just as in the WordPress Backend as well.
It would also be resource expensive to query the Child Posts of the chosen Parent Post, which is theoretically possible, but resource expensive and requires Full Custom Code.
You can see an example here how it's done with Authors (display only Posts by the same author as logged in user):
https://toolset.com/forums/topic/i-want-to-only-display-the-parent-items-of-the-current-user-in-a-select-box-2/#post-351830
You could adapt that Query that generates the [get-parents] shortcode.
But I do not recommend it, it is querying an eventually large amount of posts.
Thanks for the update. Could I accomplish something similar with a view and setting the CRED select fields recordsource to that view?
Not really.
There are 2 problems if you do it with a View:
1. Views is not a data provider but a data render engine.
Views does wrap the Loop in a default HTML div, that would break any JSON you produce with it, unless you apply a Custom Function to remove that div:
hidden link
2. You could still not let the View display posts according to the chosen parent, as Views does not have a filter for that.
You could, of course, hard code a Filter, but it would destroy the goal of the dynamic update / Display of your Selector Contents
The only possibility to achieve this is by above given Custom ShortCode that creates a Query and returns the Posts given a Parent that you choose previously in your Form.
This requires Custom Code, and it is resource expensive, I do not recommend this approach.
In case you want to follow this path, you could consider contacting one of our certified partners from this link:
https://toolset.com/consultant/
You will get the custom assistance you need to get on with your project.
Understood, thanks for getting back to me again. Might I suggest that an enhancement that leverages post type relationships for select fields is in order? I can't imagine I am the only person who would use something like this and there are plenty of use cases (many-to-many relationships especially) where this would make the presentation layer to an end user much friendlier. Thanks again.
