Hi,
I got a "schools" CPT and a "formations" child CPT.
I have an archive view displaying all formations based on several filters.
Top of the view, there is a map where I need to display "schools" that have "formations" returned by the querry.
That way, I will be able to load :
- a map of all schools ;
- for each school on the map, the list of formations (into a child view);
- a list of formations.
What would be the cleanest way to achieve this with Views ?
Thank you.
Hello, there's not a simple way to do this because you need to filter a list of parent post by child post fields. Here's how I would do it using Classic Views (not the block editor). You'll need at least 3 Views - two Formation Views and one School View.
1. Create a custom search View of Formation posts, and add all the front-end filters you want to include. Use the Loop Wizard to display the main Formation post list. This View should list all the Formations matching your custom search query.
2. Once this View is returning the correct results, duplicate it from the dashboard at Toolset > Views. Use the Loop Wizard button to redesign the loop. Choose "List with separators" as the loop style. In the loop, use a comma ( , ) as the separator and insert the Post ID field. Use the "edit" button to choose the parent School post ID (see edit-post-id.png). Delete all the other fields from the loop. Be sure "Disable the wrapping DIV around the View" is checked in the View editor. Place this View on the same page as the View of Formation posts. You should see a comma-separated list of School IDs. It's okay if there are duplicate IDs here.
3. Insert a Map shortcode in the same page as the Formation View.
4. Create a View of School posts. Add a Query Filter to filter by Post ID, set by a shortcode attribute "ids". In the loop, display the School title and insert a Map Marker using the address of this School as the location for the marker. Use a View shortcode to insert this Schools View on the same page as the map and Formation View, and use the View from #2 in the "ids" attribute. This will display a list of School posts filtered by the Formation filters, and will also display a marker on the map for each matching School. Example:
[wpv-view name="Schools by ID" ids="[wpv-view name='Duplicate Formation View from Step 2']"]
Inside the list of Schools, do you want to display ALL Formations, or just those that match the Query Filters? I'm not clear from your description if you want to display a list of ALL Formations for each School, as well as those matching the filters in a separate list?
Thank you very much.
My main view is an archive view, with several filters.
Since it's an Archive, I wasn't able to duplicate, and therefore the list of schools isn't filtered by the Archive filters.
How may I apply the Archive filters to the list of schools query ?
Thank you.
You can set up identical Query Filters in the View. If you cannot see the Query Filter panel, you must scroll to the top right corner and click Screen Options to show the Query Filter panel. Then you can create identical Query Filters, using the same URL parameters as needed.
Okay the Liste des établissements avec des formations View does not "listen" for changes in the WP Archive's filters, so it was not updating when the filters were changed. I have moved the Liste des établissements avec des formations View into the WP Archive's Loop editor, because this forces it to update whenever the filters are updated. I can see some changes now when I apply the "Formation initiale" Type filter.
Original results, reduced to unique IDs: (18) [209, 249, 256, 228, 236, 227, 200, 248, 246, 251, 242, 239, 238, 205, 268, 210, 211, 197]
Formation initiale type filter applied, then reduced to unique IDs: (7) [256, 236, 200, 242, 268, 210, 197]
Are these the results you expect to see when the "Formation initale" Type filter is applied?
Thank you.
This solved part of the problem in deed. Now the filters work OK, but the querry filter based on what term is the Archive page still don't work.
For instance on hidden link, you can count 31 formations for 5 different schools (not 18).
When applying "Formation initiale" filter, I should have only 2 schools remaining (not 7).
Thank you.
Yes, you are correct. WP Archives automatically filter based on the current archive term, but Views do not automatically filter based on the current archive term. You have added a Query Filter for the domaine term, set to respond to a URL parameter:
Select posts with taxonomy:
Domaines slug in one of those set by the URL parameter wpv-domaine
eg. <em><u>hidden link</u></em>"
However, no wpv-domaine URL parameter is added to the page. Since the View does not filter automatically, and no URL parameter is added, I do not expect the View will show filtered results. If you add the URL parameter manually, are the results accurate? hidden link
Hello and thank you very much, I see we're close now.
In deed hidden link shows the expected results.
Now I changed the View taxonomy arguments from url_parameters to shortcode attributes, then added those args to my view call, in the Archive :
As Christian is currently unavailable due to vacation I will be handling this ticket.
From what I can see you are filtering your taxonomy view on your Archive based on the Archive's slug. Confirming that you only want to display the information based on the current archive.
Meaning if you are on the Domaines archive you only want the view to filter for the Domaines and so on and so forth with the others correct?
If that is the case you will need to set the comparison logic to an OR instead of an AND.See Screenshot.
1- In deed, on the hidden link page, I need only formations with "Agroalimentaire" term to display.
That works.
2- Now, I have a second view, that should get IDs of all Schools with at least 1 formation with "Agroalimentaire" term.
That does not work, since you may see the list displays a lot more IDs than there is "Agroalimentaire" formations in the list.
3- After that, I also need the filters of the formations Archive view only to display choices where there is result. Meaning for instance on this page hidden link, the filters should only display 2 Etablissements in the Etablissements list.
4- Finally, the list of Shcools IDs must also be filtered by the dynamic filters in the Archive View. Meaning if I have the correct result at step 3, I will have 2 Etablissements in the IDs list; then if I choose one in the Etablissement filter, I will get only 1 ID in the list.
The issue seems to be the view itself that you've added to the archive.
Can you remake this view below. hidden link
When I created a separate test view, I noticed that the items filtered correctly with no issue. They are displaying the correct results.
However it should be noted that since you're getting the Parent ID with the view then you will have repeated ID's in the results since many of them share the same parent.
You can verify this by checking my test view here. hidden link
If you modify the query filter you will notice that the results change.
